Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nic
Posting Yak Master
209 Posts |
 Posted - 2009-07-15 : 12:00:05
|
| In general what type of maintenance plans should we have for the system databases (master, model etc). For User databases we generally do nightly backups (BAK and TRN) and then weekly we check data integrity, rebuild indexes and rebuild statistics. For example, I have noticed when I try to add system databases to a transaction log backup, it tends to fail. So I'm not really clear how much maintenance we should be doing on the system databases. We have always tried to do the same maintenance as the user databases but I've never really know what is preferred. Also, if you include all databases in a maintenance plan (using the wizard) does it also include tempdb? I thought I read somewhere tempdb is not included.Any suggestions would be appreciated.Thanks,NicNic |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-07-15 : 12:40:44
|
| Just do Full Backup for all system databases in Maintenance Plan. You should be good. |
 |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-07-15 : 14:48:11
|
| It is likely the transaction log backup that fails on the system databases.I fixed this by creating 2 jobs in enterprise manager.1 performing full backup only on the system databases,2nd performing all the full and tranaction backups for everything else. |
|
|
|
|
|
|
Maintenance Plans for System Databases