Home Forums SQL Server 2008 SQL Server Newbies DBCC SHRINKFILE failing with error Msg 3140, Level 16, State 5, Line 1, Could not adjust the space allocation for file RE: DBCC SHRINKFILE failing with error Msg 3140, Level 16, State 5, Line 1, Could not adjust the space allocation for file

  • August 28, 2012 at 5:28 am

    #1530714

    Thank you for info I'm rather new to this so it's nice to be pointed in the right direction.

    I've ran your query and no rows were returned for any of the file groups.

    Cheers,