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 |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2007-12-26 : 00:44:53
|
| I got a space issue on F driveTotal drive capacity 581 GBNow free space is 4.4 GB ONLYF:\MSSQL\DATA\..NDF---163072128(163 GB)F:\MSSQL\DATA\...MDF--441785344(441 GB)I am trying to shrink the database to get some free space on F:\ drive but "US\SVC_LADadmin" is executing delete statement on this database. so I could not perform any activity at this timePlease suggest how to proceed further? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-26 : 10:00:49
|
| You should shrink in smaller sizes and not all at once. Search the script library for dbcc shrinkfile and you'll find MVJ's script to do this. Shrinking will only help if you have free space inside the database files though. How much free space do you have in each file?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
|
|
|
space issue