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 Thursday, March 7, 2013 5:54 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 7, 2014 9:29 AM
Points: 1, Visits: 74
Excellent tip tedd!! It solved my issue too
Post #1428336
Posted Wednesday, May 15, 2013 4:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 8, 2015 3:04 AM
Points: 1, Visits: 107
Thanks Ted! This worked for me too. Any idea why the error comes up in the first place?
Post #1453008
Posted Thursday, May 23, 2013 12:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 20, 2013 11:11 PM
Points: 1, Visits: 27
Great , thanks Ted...increasing a little space to data file, it solved the issue
Post #1455820
Posted Wednesday, October 23, 2013 12:20 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 1, 2014 11:45 AM
Points: 10, Visits: 205
Changing Auto Shrink to False and Increasing the size worked for me to shrink files.
Post #1507787
Posted Tuesday, November 11, 2014 9:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 9:28 AM
Points: 1, Visits: 52
Thanks for the post, this worked for me too!
Post #1633507
Posted Tuesday, January 6, 2015 5:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 6, 2015 5:41 AM
Points: 1, Visits: 0
didn;t work for me as only 1GB free on the data drive on the server.
freed up a bit of space and then the shrink worked.
something else to look out for.
Post #1648622
Posted Friday, January 9, 2015 5:05 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: Yesterday @ 1:32 AM
Points: 559, Visits: 1,514
Thanks Ted - this helped me out of a tight spot today.
Post #1649791
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse