DUMP TRANSACTION [XXX] WITH NO_LOG
BACKUP LOG [XXX] WITH NO_LOG
DBCC SHRINKDATABASE([XXX])
DUMP TRANSACTION [XXX] WITH NO_LOG
BACKUP LOG [XXX] WITH NO_LOG
DBCC SHRINKDATABASE([XXX])
转载于:https://www.cnblogs.com/aimigi/archive/2013/01/16/2862723.html