Mohan Kumar
SSCertifiable
Points: 5365
More actions
March 20, 2008 at 12:45 pm
#792193
use dbcc shrinkfile with notruncate and then truncateonly. It will do what you are expecting if there is no open transaction.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply