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!
Hi
I don't really use maintenance plans as I prefer to write my own, but I will
try to answer inline:
"rupart" wrote:

> Hello guys,
> I have few Qs..
> 1) I created DMP and chose all database for backup. BUt master db doesnt get
> backup. Any idea?
I would expect the "All Databases" option to do what it says.

> 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?
I believe the reorganize data and index pages does a DBCC DBREINDEX
(profiling the plan when it is running will show what it does). This is very
important as it will take out fragmentation in the pages and therefore reduce
the number of reads you need to get the data.
SQL Server keeps statistics about the distribution of the key values in each
index and uses these statistics to determine which index(es) to use in query
processing. Query optimization depends on the accuracy of the information,
therefore keeping these up-to-date is important.

> 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?
http://msdn.microsoft.com/library/de...rverE-mail.asp
More links:
http://www.aspfaq.com/show.asp?id=2403
Alternatively you may want to use SMTP:
http://www.sqldev.net/xp/xpsmtp.htm

> 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)
>
The best place start when requiring information on SQL server is usually
Books online. Time spent reading this will usually pay itself back
substantially in the future.
The latest version can be downloaded from:
http://www.microsoft.com/sql/techinf...2000/books.asp
Online copies can be found at
http://msdn.microsoft.com/library/de...asp?frame=true
e.g the restore command and examples at:
http://msdn.microsoft.com/library/de...asp?frame=true

> Thanks a lot guys!
>
HTH
John
|||Before turning out automatic fragmentation remoal in a maintenance plan, I
recommend you read the whitepaper below which explains when and how it is
best to remove fragmentation, and when it simply doesn't matter.
http://www.microsoft.com/technet/pro.../ss2kidbp.mspx
Regards
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
news:92DC9AC7-705F-4444-B84B-793BBF4F5250@.microsoft.com...
> Hi
> I don't really use maintenance plans as I prefer to write my own, but I
will[vbcol=seagreen]
> try to answer inline:
> "rupart" wrote:
get[vbcol=seagreen]
> I would expect the "All Databases" option to do what it says.
options,[vbcol=seagreen]
are
> I believe the reorganize data and index pages does a DBCC DBREINDEX
> (profiling the plan when it is running will show what it does). This is
very
> important as it will take out fragmentation in the pages and therefore
reduce
> the number of reads you need to get the data.
> SQL Server keeps statistics about the distribution of the key values in
each
> index and uses these statistics to determine which index(es) to use in
query
> processing. Query optimization depends on the accuracy of the
information,
> therefore keeping these up-to-date is important.
>
>
http://msdn.microsoft.com/library/de...rverE-mail.asp[vbcol=seagreen]
> More links:
> http://www.aspfaq.com/show.asp?id=2403
> Alternatively you may want to use SMTP:
> http://www.sqldev.net/xp/xpsmtp.htm
restoring it[vbcol=seagreen]
restore)
> The best place start when requiring information on SQL server is usually
> Books online. Time spent reading this will usually pay itself back
> substantially in the future.
> The latest version can be downloaded from:
> http://www.microsoft.com/sql/techinf...2000/books.asp
> Online copies can be found at
>
http://msdn.microsoft.com/library/de...asp?frame=true
> e.g the restore command and examples at:
>
http://msdn.microsoft.com/library/de...asp?frame=true
>
> HTH
> John