Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 MDF file not growing even though autogrow is set

Author  Topic 

Throfin
Starting Member

1 Post

Posted - 2010-07-28 : 09:50:52
I have a customer using SQL 2000 (8.0.760) and their database is currently 838.67 MB with 10% growth and unlimited max size. The log file is 1 MB with the same growth settings. However, the customer receives an error stating the log file is full when saving data to the database. The available space is showing 0.55 MB.

Is there a way to force the files to grow or set the space available to a larger value?

Thanks in advance!

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-07-28 : 10:53:09
unbelievable...
Do you have enough free space on that harddrive?


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2010-07-28 : 10:56:18
You sure the disk that the LOG file is on is not full?
Go to Top of Page
   

- Advertisement -