saranya.priyadharshini (12/13/2012)
How i Can recover Free space?? Highly Suggest me!!
DBCC ShrinkFile. There's no other way (other than copying the data to a new DB and dropping the old one)
Let me guess, lots of LOB data? That makes shrink very slow.
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