Space available appears as 0.00 MB in Sql Server 2000 database
Posted on 2009-04-08
I have a database 'myDB' when I right click it and select properties. In the first tab 'General' it says the following:
Space available: 0.00 MB
In the second tab 'Data Files': 1151 Space allocated (MB)
In the third tab 'Transaction Log': 1046 Space allocated (MB)
When I go to where the files are on my server, the .mdf file shows 1,178,368KB, and the .LDF file shows 1,070,720KB.
How can I have space available for this database?
Thank you in advance.