December 29th, 2003, 11:28 AM
sql-database will not autogrow
I am running SQL 2000 SP3 and I can not get the sql database to autogrow, I have to manually set the database size larger every other day. What can I do to remedy this or where should I look, anything would be apreciated.
Thank you to everyone who even takes the time to just read this
December 30th, 2003, 04:52 PM
Go to Enterprise Manager. Select the Server, then expand Databases, select your DB, right click and select Properties. In the dialog box that pops up. go to the Data Files tab and check the Automatically grow file checkbox. Do the same to the Transaction Log tab, if needed.
Up the Irons
What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
"Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest
Down with Sharon Osbourne
"I wouldn't hire a butcher to fix my car. I also wouldn't hire a marketing firm to build my website." - Nilpo
December 30th, 2003, 05:07 PM
The problem is not where to configure it, but why it is not working properly. At what size xmb should SQL autogrow the file to the next size?