• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 747
  • Last Modified:

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 .
0
hazelibn
Asked:
hazelibn
  • 2
1 Solution
 
JohnnyBoyCommented:
1). Click on the name, bring up the "Edit Database" window and
select Recaclulate...

2). In the same window, but on the "Options" panel, there is a tick box that is marked "Truncate Log On Checkpoint", this should be set to keep the log pretty empty
0
 
Victor SpiridonovCommented:
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.
0
 
Victor SpiridonovCommented:
You can also try doing 'checkdb' on your database, could be, that  space for tables is incorrectly allocated.
0
 
Jim_SQLCommented:
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.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now