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
greg.huxley
SSC Eights!
Points: 915
More actions
September 19, 2012 at 4:32 am
#1539475
Cheers opc.three will try this out when our system admin is back in the office. After reading the blogs you pointed me to I don't think it's worth doing the shrink anyway as the files are quite small.
Thanks,
Greg