July 28, 2010 at 7:55 am
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.
sp_spaceused indicates:
reserved data index_size unused
857784 KB417128 KB292432 KB148224 KB
Is there a way to force the files to grow or set the space available to a larger value?
Thanks in advance!
July 28, 2010 at 8:02 am
When you say: The available space is showing 0.55 MB, is this in the database files?
Second, have you checked the available disk space on the disk drives themselves. If the disks are full, the database and log files can't grow.
July 28, 2010 at 8:09 am
Thanks for the reply. The space available mentioned previously is the unallocated space listed by the sp_spaceused procedure. I am also using SQL Server Management Studio 2008 to connect to their database, and that value also shows on the General tab of the database properties under "spae available".
The hard drive has 32 GB available.
July 28, 2010 at 9:34 am
Have you tried to manually increase the size of the files? This can be done via the database properties (gui) or using T-SQL (alter database ...).
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply