DUMP TRANSACTION [TBNAME] WITH NO_LOG
BACKUP LOG [TBNAME] WITH NO_LOG
DBCC SHRINKDATABASE([TBNAME])
1.清空日志：
DUMP TRANSACTION [databasename] WITH NO_LOG
2.截断事务日志：
BACKUPLOG [databasename] WITH NO_LOG
3.收缩数据库：
DBCC SHRINKDATABASE([databasename])
注：数据库名陈最好加上[]