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 |
|
Rhysw
Starting Member
2 Posts |
 Posted - 2003-02-24 : 21:04:02
|
| We have a database that has recently blown out it's free space, and will not return it to the OS.The Data space used is 4560MB, and in addtion there is 1500MB free space. Total space used by database is just over 6 GB. The database has a full backup every 24 hours, with transaction log backups every 8 hours.MS SQL7 with service pack 4 installed, the OS is NT6 with service pack 6.We have not experienced any other problems with similar databases on any of our other servers and are now stuck for what to do next.The database is set to autoshrink, with 10 % automatic file growth.We have tried reindexing, dbcc shrinkdatabase, and dbcc checkdb to check for any errors.Has anybody got any solutions on how to release this free space back to the OS, please let me know.Thanks in advanceRhysw |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-24 : 21:49:17
|
| Have you tried DBCC SHRINKFILE? I can't remember if this is a valid command in 7.0 though, but I believe it is. |
 |
|
|
Rhysw
Starting Member
2 Posts |
Posted - 2003-02-26 : 15:44:55
|
| Thanks,We will try this, we now have a copy of the database restored to another machine so we can try various things without killing the live database... |
|
|
|
|
|
|
How do you remove excessive free space