DataBase Maintenance Plan(DMP) Questions | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DataBase Maintenance Plan(DMP) Questions

Hello guys,
I have few Qs.. [?] 1) I created DMP and chose all database for backup. BUt master db doesnt get
backup. Any idea? 2) if in each and every database i checked the "update statistics" options,
do i need to check "reorganize data and index pages" in the DMP wizard? are
they different? what way they are different? 3) what’s the best method to use for email.SQLMail or Exchange? Any good
link to configure the exchange and outlook to send emails? 4) Finally, is there any good links that shows step by step on restore
process? i am blur , esp, at the backup the transaction log and restoring it
back when the database is corrupted… (looking for up to the time restore) Thanks a lot guys!

1) Choose seperate plan to backup system databases and try to divide the huge databases into a seperate plan. 2) Both the options will give same result by updating the plan for optimum performance, if you choose ‘reorg…’ then ensure to schedule this during less traffic hours. 3) Search under the forum for SQLMail topics which gives mre indepth. 4) for backup strategy in addition to books online help. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.