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 |
|
pdset
Constraint Violating Yak Guru
310 Posts |
 Posted - 2008-07-15 : 18:58:13
|
| Hi Experts,Can Anyone let me know while shrinking the file which is Primary File has generated the message.DBCC SHRINKDATABASE: File ID 1 of database ID 80 was skipped because the file does not have enough free space to reclaim. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-15 : 22:50:27
|
| Ensure target size you specified is bigger than db used size. |
 |
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2008-07-16 : 19:20:29
|
| Thanks for it.I am new for this.Can You be specific of target to the DB Used size, as how I need to monitor and steps to tackle.Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-16 : 23:02:43
|
| You can get used size by running sp_spaceused under the db. If used size is 10gb, target file size in dbcc should be bigger than that like:dbcc shrinkfile (file_name, 11000) |
|
|
|
|
|
|
Shrink FIle