1、DUMP TRANSACTION DataBase_Name WITH NO_LOG
2、BACKUP LOG DataBase_Name WITH NO_LOG
3、DBCC SHRINKDATABASE(DataBase_Name)
1、DUMP TRANSACTION DataBase_Name WITH NO_LOG
2、BACKUP LOG DataBase_Name WITH NO_LOG
3、DBCC SHRINKDATABASE(DataBase_Name)