hazelibn
asked on
Space Available in MS SQL
We have some questions about Data Space Available in SQL Server Database
Condition our Db:
O/S = NT
Datasize in SQL = 2000 MB
Data space available = 0.00 MB
Log Size = 1000 MB
log space Available = 0.00 MB
the above info that there is no more space available , but we could entry our transaction (record) into DB.
1. How could it be happenned ?
2. Is there any solution ? , cause we are worry it's gone be a "time bomb" for DB space.
Thank you .
Condition our Db:
O/S = NT
Datasize in SQL = 2000 MB
Data space available = 0.00 MB
Log Size = 1000 MB
log space Available = 0.00 MB
the above info that there is no more space available , but we could entry our transaction (record) into DB.
1. How could it be happenned ?
2. Is there any solution ? , cause we are worry it's gone be a "time bomb" for DB space.
Thank you .
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I have exactly the same situation, the proposed solution dosn't help. To date the only way to 'solve' it was renaming database, creating a new one and transferring data to it.
You can also try doing 'checkdb' on your database, could be, that space for tables is incorrectly allocated.
The other suggestions are what I'd try first as well, but a tip that might come in handy is that if you run DBCC checktable(syslogs) it will also update the 'reported' available space in your database.