Unable to shrink Datafile

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Unable to shrink Datafile

Unable to shrink Datafile

Rate Topic

Display Mode

Topic Options

Author

Message

mahesh.dasoni

Posted Friday, September 14, 2012 6:24 PM

SSC Journeyman

Group: General Forum Members
Last Login: Saturday, May 04, 2013 1:55 AM
Points: 81, Visits: 858

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

Post #1359750

matt.newman

Posted Sunday, September 16, 2012 8:17 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 10, 2013 8:25 AM
Points: 170, Visits: 423

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.

Post #1359884

« Prev Topic | Next Topic »

Permissions