Home Forums SQL Server 2005 Administering DBCC Shrinkfile & Shrinkdatabase RE: DBCC Shrinkfile & Shrinkdatabase
Mohan Kumar
SSCertifiable
Points: 5365
More actions
March 20, 2008 at 10:42 am
#792123
use
DBCC shrinkfile (filename, expected size in MB , notruncate)
once this is completed then
DBCC shrinkfile(filename, expected size in MB , truncateonly)
This will do trick.
[font="Verdana"]--www.sqlvillage.com[/size][/font]