SQL Server Performance

DataBase Maintenance Plan(DMP) Questions

Discussion in 'General DBA Questions' started by rupart, Mar 10, 2005.

  1. rupart New Member

    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!
  2. satya Moderator

    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)http://www.sqlteam.com/Item.asp?ItemID=2339 for backup strategy in addition to books online help.



    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page