Re: Maintenance Plans - Master, MSDB, etc.

From: Anthony Thomas (ALThomas_at_kc.rr.com)
Date: 01/24/05 

Date: Sun, 23 Jan 2005 22:36:55 -0600

Oh, but do make sure you do the integrity checks!

Anthony Thomas 

-- 
"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:efErdhAAFHA.3616@TK2MSFTNGP11.phx.gbl...
Optimizations do not really apply to the system dbs with the MP since it
uses DBCC DBREINDEX and that is not supported on system tables.
-- 
Andrew J. Kelly  SQL MVP
"Mark" <Mark@nowhere.com> wrote in message
news:e1kwcG$$EHA.3416@TK2MSFTNGP09.phx.gbl...
>I currently have a maintenance plan setup to do typical
> optimizations/reindexing of our user databases.  Is it a good practice to
> do
> this on the Master database or the MSDB database?  The MSDB seems like the
> better candidate of the two since we work with DTS quite a bit. BUT, by a
> "bit" I mean we have a MSDB database around 200 MB.
>
> Thanks in advance.
>
> Mark
>
>