Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

shrink fails with error - File ID of database ID cannot be shrunk as it is either being shrunk by another process or is empty Expand / Collapse
Author
Message
Posted Wednesday, June 11, 2008 12:03 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 2:47 PM
Points: 88, Visits: 351
This is an fyi (no response necessary).

I got this error and researched it and found no good answer for how to deal with it:

"File ID 5 of database ID 8 cannot be shrunk as it is either being shrunk by another process or is empty"

One post suggested that it was a memory issue, but it also suggested the only way to deal with it was to restart SQL. I don't have that luxury, so I cleared my cache and reran the shrink and the shrink worked.

DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE


Thanks, Deb


Post #515417
Posted Wednesday, June 11, 2008 1:21 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 16, 2014 6:06 AM
Points: 6,259, Visits: 2,030
If Autoshrink is "ON" and you tried to run a "dbcc shrinkfile" you could get that message.




* Noel
Post #515458
Posted Thursday, August 20, 2009 1:07 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, January 14, 2011 1:53 AM
Points: 11, Visits: 161
See the Connect bug "DBCC SHRINKFILE and SHRINKDATABASE failing after backup" at
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=291408
Post #774034
Posted Tuesday, March 16, 2010 5:28 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 12:24 PM
Points: 2, Visits: 183
One more thing to try that worked for me when I received this error message. I just increased the data file by a few MB and then tryed to do the Shrink again. It worked fine. It seems like adding a few MB to the data file resets an internal counter or switch that tells it it's not in the middle of a shrink now.
Post #884318
Posted Monday, September 6, 2010 6:53 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, May 23, 2012 10:27 PM
Points: 87, Visits: 161
thanks Ted, it worked for me as well....now to find out who is growing my tempdb 1 AM in the morning to rediculas sizes ..


Post #981092
Posted Wednesday, October 13, 2010 9:13 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, October 9, 2014 3:59 PM
Points: 30, Visits: 606
Thanks Ted. It works for me, too.
Post #1003725
Posted Monday, November 8, 2010 8:51 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 12:48 PM
Points: 2,618, Visits: 2,236
Whatta guy, Ted. Bailed me out also.

Mike

The more you know, the more you know you don't know.

_____________________________________________________________________________

A word to the wise ain't necessary, it's the stupid ones who need the advice ...Bill Cosby
Post #1017242
Posted Saturday, March 19, 2011 9:36 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 28, 2013 3:21 AM
Points: 2, Visits: 176
Thanks A lot Ted. This worked for me.

Regards,
Manjunath C Bhat,
www.manjunathcbhat.in


Thanks & Regards,
Manjunath C Bhat,
http://manjunathcbhat.blogspot.com,
http://manjunathcbhat.wordpress.com
Post #1080849
Posted Tuesday, March 22, 2011 5:58 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, April 11, 2014 6:50 AM
Points: 517, Visits: 346
More often than not, the best thing to do is to not shrink at all though.



Vegard Hagen
Norwegian DBA, blogger and generally a nice guy who believes the world is big enough for all of us.

@vegard_hagen on Twitter
Blog: Vegard's corner (No actual SQL stuff here - haven't found my niche yet. Maybe some day...)

"It is better to light a candle than to curse the darkness."
(Chinese proverb)

Post #1081915
Posted Tuesday, March 22, 2011 12:46 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 26, 2012 8:19 AM
Points: 1, Visits: 32
Thanks Ted - helped me too!
Post #1082259
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse