question

Wilfred van Dijk avatar image
Wilfred van Dijk asked

system databases - what not to do on these databases?

Hi, I was triggered by an article from Aaron about a "new" system database in Denali [link text][1] after I recently installed a new SP to reindex databases [link text][2]. This SP is not indexing the Master database. I see a lot of script which are not touching the system databases. I know TempDB is a scratch environment, so I agree to skip this database. But which maintenance activities are not recommended / forbidden on system databases? [1]: http://sqlblog.com/blogs/aaron_bertrand/archive/2011/07/08/sql-server-v-next-denali-breaking-change-to-system-databases-database-id-db-id.aspx [2]: http://www.sqlfool.com
maintenancesystem-databases
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David Wimbush avatar image
David Wimbush answered
Personally, I wouldn't do anything to system databases. I figure they are called system databases for a reason :).
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Raj More avatar image
Raj More answered
In terms of maintenance, I would do a subset of maintenance tasks against system databases: 1. Run `DBCC CheckDb` 2. Back up the databases and test the restores on a different machine on a fixed schedule (to test, and for practice). 3. If you run a lot of jobs, then maybe the tables related to Job History in MSDB.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.