December 29, 2009 at 7:32 am
I had a database in SQL 2005 SP2 CU8 Win2003 64 bit that in looking at the reports autoextended on 12/15 of 100mb and then yesterday extended 300gig. I have seen this before where no one changes the growth rate but something within SQL Server makes for growth rate an extremely high number. I thought there was a fix way back in SP1 or SP2 or something for that. Does anyone know anything about this or know of a fix for this?
December 29, 2009 at 2:16 pm
What is the autogrowth setting for that database now? Review the standard report for Disk Usage which will include a record of all autogrowth events since the last time SQL Server was started.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 29, 2009 at 2:20 pm
I reset it to 100MB. I looked at the autogrowth and it had been autogrowing at that rate all along until yesterday and somehow it was at that high autogrow rate. I know... someone must have changed it.... however, no one knows the login/password to this SQL Server so I can be the only one that changes it... odd! Dec 15th was the last time it autogrew last.
December 29, 2009 at 3:32 pm
What service pack are you on? There was a bug that was partially corrected in SP1 and fully corrected in SP2 that corrects this issue.
December 29, 2009 at 3:37 pm
You reset it to 100MB from what? If the last time it autogrew was back on the 15th - then the only other option is that someone manually grew the file. Anybody that has the right permissions can issue an ALTER DATABASE statement and grow the file - which will not show up as an autogrowth event in the default trace.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply