Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
itaka19d
Starting Member
2 Posts |
 Posted - 2004-08-17 : 04:20:04
|
| hy everybody,I have a 12 gb database. It is configured to automaticaly grow in blocks of 250 MB. The avaible space at the E.M. DB is 0.0 MB. but the HD free space is 13GB. I've tryed to check the DB wiht the CHECKDATABASE command and all was right. I've also forced the DB size to 13 GB. Doing that the avaible space contiunes to 0.0 MB but the allocated space shows 1 GB avaible. After that I can work for a time until a srink operation is made, which return me to the original situation. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-17 : 12:07:51
|
| So you do have free space in the MDF file? You can view it with sp_spaceused.Tara |
 |
|
|
itaka19d
Starting Member
2 Posts |
Posted - 2004-08-20 : 01:49:21
|
| I got unallocated space returned in negative value. But I've used (sp_spaceused @updateusage = true) and then all has functioned correctly.ThanksBest regardsMarc |
|
|
|
|
|
|
Problems with Database available space