biohug (9/8/2012)
i tried "DBCC SHRINKFILE (N'A1', 211689)" but took so long and gave a strange error:Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Did someone perhaps run KILL on the session doing the shrink?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability