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 |
|
-Dman100-
Posting Yak Master
210 Posts |
 Posted - 2006-03-18 : 22:44:31
|
| I'm creating a maintenance plan for my system databases [master, model, msdb]. This is on my own private server, which I use for development and testing.For data optimization, I have checked reorganize data and index pages and selected reorganize pages with the original amount of free space. Being as this is for the system databases, I'm looking for input on this being an appropriate choice. Why or why not?Is the option to remove unused space from the database files an appropriate choice for system databases? If so, what is a rule of thumb on growth limits and amount of space to remain after the shrink?These are options I wasn't completely certain about and any input would be helpful.Thanks.Regards,-D- |
|
|
Kristen
Test
22859 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-20 : 18:59:50
|
| Optimizations option in the maintenance plan should not performed on system databases.Tara Kizeraka tduggan |
 |
|
|
-Dman100-
Posting Yak Master
210 Posts |
Posted - 2006-03-20 : 19:46:20
|
| That's good to know. I wasn't sure since it was with the system databases. Thanks for the input.Regards,-D- |
|
|
|
|
|
|
system backup maintenance plan