July 26, 2011 at 11:27 pm
On the msdb database, I've always just left the Autogrowth to "By 10 percent, unrestricted growth" and not really managed it in the same way as I would a user database.
What's the common best approach here? What do the rest of you do?
July 27, 2011 at 12:52 am
PhilipC (7/26/2011)
On the msdb database, I've always just left the Autogrowth to "By 10 percent, unrestricted growth" and not really managed it in the same way as I would a user database.What's the common best approach here? What do the rest of you do?
I do not see any problems in your approach as far as MSDB is concerned. the above autogrowth setting reminds me of the default log growth setting. I would however suggest that for the datafile you keep the higher auto growth setting or just allocate a decent size like 4-5 GB. I believe we cannot predict the size of new MSDB as it depends upon how many jobs, alerts, packages you going to create.
This was just my point of view. some expert will surely add better information here.
chandan
July 27, 2011 at 6:07 am
I manage it the same way as my other dbs. I presize it for 1-3 years ahead of time based on backup file size growth and projected size in x years.
As of now my server won't need any space to grow for a solid 24 months. Nice feeling ;-).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply