sqladmin 45377 (11/4/2012)
Thanks so much for the info, George. I'll uncheck that shrink option and keep an eye on the size.I'll have to brush up on how to best adjust the growth settings for this DB. It's about 2.5GB and has grown very slowly over the last few years. Any recommendations?
For the data file I would say about 100MB, certainly avoid growth factors stored as a percentage. For the log file a growth factor of 64MB. As for what size it should be that depends on a number of factors, recovery mode mainly. what is your log backup strategy? if you take log backups whats the frequency and size of the largest log backup?read this
I'll run a Reindex manually from Enterprise Manager, though if that operation is already running weekly (Sunday early morn, as part of the current Plan), isn't that accomplishing the same thing?
it will be, its just that the work done by the reindex would have been ruined by the shrink, which fragments indexes as it just attempts to move data to the front of the file without taking into account what object that data relates to. Your largest amount of log activity will be when the reindex is run.
---------------------------------------------------------------------