January 9, 2012 at 8:30 am
I am new to SQL (Oracle and Progress is my past experience). I had a situation where autogrow was not functioning properly. The autogrow was set to 10% of the database (sized at 4.95 Gb). I was confused as to why the autogrow was failing, but I had to get my database functional first. We have a few part-time SQL people around our office and one person did the following:
From Enterprise Manager
•Verify the database is not being used
•Right click on DB and go to properties
•Go to Data Files tab
•Deselect autogrow
•Under file growth select radio button “In Megabytes”.
•Enter a significant number of megabytes to grow. Ex: 100MB.
•Click OK
•Go back to data files tab under properties and check automatically grow files.
•Select by percentage and then enter a percentage for the file to grow.
•Click OK
In my mind, I cannot believe that simply changing the auotgorw value with autogrow off could grow the database. Am I all wet here?
January 9, 2012 at 11:30 am
I should note here that this is an SQL2000 database
January 9, 2012 at 12:00 pm
I'm thinking they may have resized the database without the autogrow.
How large is the database currently? Is it 4.95Gb or was that the starting size of the DB?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 9, 2012 at 12:38 pm
There is an issue with SQL 2000 that reports space as a negative number when looking at sp_spaceused and also causes the database not to grow automatically due to this. I can't put my finger on the bug atm, but running dbcc updateusage for the database in question fixes the current issue. This is not a permament fix and might re-occur over time.
January 10, 2012 at 7:04 am
Thanks to all of you for all of your input! As it turns out the person who posted what he had done has since retracted that statement and has indicated that he changed the max size, which now makes the growth of the database less mysterious. This person has been made to disappear, but that is a new mystery!
January 10, 2012 at 8:53 am
Thanks for the update.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply