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: Friday, March 20, 2015 7:32 AM
Points: 1, Visits: 86
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: Sunday, April 5, 2015 4:41 AM
Points: 1, Visits: 130
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: Tuesday, April 28, 2015 1:28 PM
Points: 10, Visits: 206
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: Tuesday, May 12, 2015 3:33 AM
Points: 559, Visits: 1,538
Thanks Ted - this helped me out of a tight spot today.
Post #1649791
Posted Sunday, February 1, 2015 4:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 12, 2015 10:15 AM
Points: 1, Visits: 142
Wow it actually worked for me too when nothing else short of a restart would. Thanks so much, my on-call at 1am just got a whole lot better
Post #1656581
Posted Sunday, March 1, 2015 7:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 19, 2015 7:23 AM
Points: 7, Visits: 322
Thanks.. This worked for me also. In my case "Auto Shrink" option was enabled. Even after disabling it i was not able to shrink the file manually and was getting the same error as mentioned in this post. So as suggested here, i increased the size of data-file by few MBs and then did a manual shrink. BTW mine was also SQL server 2005.

Thanks again!
Post #1664666
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse