July 28, 2008 at 6:23 am
BAD-DBA-DAB (7/27/2008)
. in the mean time u cud try shrinking the database.
Do not shrink the database unless disk space has become a critical issue....There is nothing to be gained by this process. Why do people insist on doing this? Google it or search this site on reasons for NOT shrinking the database!
-- You can't be late until you show up.
July 28, 2008 at 8:06 am
tosscrosby (7/25/2008)
My best advice is to monitor growth
Is growth history kept anywhere? Is there a query I can run that will tell me when a growth has occurred?
July 31, 2008 at 7:44 am
you can get the fact that it happened out of the default trace, see: http://sqlblog.com/blogs/tibor_karaszi/archive/2008/06/19/did-we-have-recent-autogrow.aspx
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply