September 14, 2012 at 6:24 pm
I had a table which was 100 gb and whole database size was 150 GB.
I have archived that table to another server and dropped the table from the existing server and freed 100 GB space but i am unable to shrink my database as it is giving me the below error:-
File ID 1 of database ID 7 was skipped because the file does not have enough free space to reclaim.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
sp_spaceused output is as follows::
database_name Database Size unallocated space
test 157449.31 MB 113945.80 MB
September 16, 2012 at 8:17 am
Sometimes the file just won't go. Did you check the physical files to make sure that their sizes are as big as the statistics say?
DBCC updateusage
Are you using a TRUNCATE ONLY on the shrinkfile? Did you rebuild all the indexes so table data could be stored at the end of the file?
You are likely to get grilled by a lot of people about to ask why you need to shrink the file to begin with.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply