July 9, 2003 at 8:25 am
I don't know what's going on. The application is running fine, but I have not seen a database is staying at 0.0
I have never seen is a database stay at 0.0.
There are two datafiles
a.mdf
b.ndf
a.mdf is 1238 meg, 20meg increment max size 2048meg
b.ndf is 638 meg, 20meg increment max size 2048meg
There is enough physical disk space. Am I worring for nothing? I do not see errors in the error log.
Could it be a lack of activity and the file has not needed to expand for a period of hours?
Joseph
July 9, 2003 at 9:29 am
Do you mean database available space is 0.00MB? Try to run sp_spaceused @updateusage = true to the database and go back to check it.
July 9, 2003 at 11:43 am
THANKS, that was it.
Joseph
July 9, 2003 at 1:52 pm
quote:
Do you mean database available space is 0.00MB? Try to run sp_spaceused @updateusage = true to the database and go back to check it.
What's the difference between that and "DBCC UpdateUsage"? I usually just run the DBCC command to fix things.
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
July 9, 2003 at 2:04 pm
With @updateusage = 'true', sp_spaceused actually executes 'DBCC UpdateUsage' in it.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply