Home Forums SQL Server 2005 Administering shrink fails with error - File ID of database ID cannot be shrunk as it is either being shrunk by another process or is empty RE: shrink fails with error - File ID of database ID cannot be shrunk as it is either being shrunk by another process or is empty

  • May 14, 2012 at 4:16 am

    #1487001

    First i increase size of datafaile by 500 Mb but i recieved same error , but next time when i increased same by 1 MB it worked. Thanks

    In one of blogs i found this as well

    "According to Microsoft, the problem was "DBCC SHRINKFILE was unable to run on the primary data file of the user database "DatabaseName" because a background operation which had obtained a latch for the required shrink operation previously was not released."