shrink fails with error - File ID of database ID cannot be shrunk as it is either being shrunk by another process or is empty

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » shrink fails with error - File ID of database...

22 posts, Page 1 of 3

1 2 3 »»»

shrink fails with error - File ID of database ID cannot be shrunk as it is either being shrunk by another process or is empty

Rate Topic

Display Mode

Topic Options

Author

Message

Deb Anderson

Posted Wednesday, June 11, 2008 12:03 PM

SSC 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

Cool

Post #515417

noeld

Posted Wednesday, June 11, 2008 1:21 PM

SSCertifiable

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:39 PM
Points: 6,260, Visits: 1,977

If Autoshrink is "ON" and you tried to run a "dbcc shrinkfile" you could get that message.

* Noel

Post #515458

Paul Storm-444906

Posted Thursday, August 20, 2009 1:07 AM

Grasshopper

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

Ted Henderson

Posted Tuesday, March 16, 2010 5:28 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 19, 2012 7:22 PM
Points: 2, Visits: 160

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

CoetzeeW

Posted Monday, September 06, 2010 6:53 AM

SSC 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

Sunny1

Posted Wednesday, October 13, 2010 9:13 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 12:35 PM
Points: 25, Visits: 461

Thanks Ted. It works for me, too. Smile

Post #1003725

mbricker-600840

Posted Monday, November 08, 2010 8:51 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 12:48 PM
Points: 2,218, Visits: 2,075

Whatta guy, Ted. Bailed me out also.

Mike

_____________________________________________________________________________

A word to the wise ain't necessary, it's the stupid ones who need the advice ...Bill Cosby

Post #1017242

bhat.manjunath7

Posted Saturday, March 19, 2011 9:36 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 09, 2013 6:09 AM
Points: 2, Visits: 155

Thanks A lot Ted. This worked for me Smile

.

Regards,
Manjunath C Bhat,
www.manjunathcbhat.in

Thanks & Regards,
Manjunath C Bhat,
http://manjunathcbhat.blogspot.com,
http://manjunathcbhat.wordpress.com

Post #1080849

Vegard Hagen

Posted Tuesday, March 22, 2011 5:58 AM

SSC-Addicted

Group: General Forum Members
Last Login: Sunday, May 12, 2013 11:41 PM
Points: 494, Visits: 325

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

anne.johansen

Posted Tuesday, March 22, 2011 12:46 PM

Forum 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 »

22 posts, Page 1 of 3

1 2 3 »»»

Permissions