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-08-11 : 21:28:04
|
| Hi,While I am doing the Shrinking of the database I got the following error.Can anyone tell me as to how I need to solve this problem.Sometimes, it says Primary file cannot be shrinked as there not enough space to carry the shrinking.DBCC SHRINKDATABASE: File ID 1 of database ID 7 was skipped because the file does not have enough free space to reclaim.Thanks in advance. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-11 : 22:14:36
|
| You can't shrink below minimum size. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-11 : 22:43:27
|
| Is there any unused space in the file? Nothing to shrink if not. |
|
|
|
hitesh6221
Starting Member
28 Posts |
Posted - 2008-08-12 : 01:24:45
|
| How much space available in your dirve please check (Drive that content datafiles)Regards,Hitesh Soni |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-08-12 : 01:56:16
|
| If you need to make smaller , consider moving\deleting dataJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2008-08-12 : 02:10:23
|
| Thanks Experts for your time and replies.I have to say after the completion of shrinking of the databases and its files there is not much space is available to shrink further and needs to either increase the disk space or delete existing data which is not so vulnerable.Once again thanks |
|
|
|
|
|
|
SHRINKING DATABASE FILES