USE [master]GOALTER DATABASE DBNAME SET RECOVERY SIMPLE WITH NO_WAITGOALTER DATABASE DBNAME SET RECOVERY SIMPLE --简单模式GOUSE DBNAMEGODBCC SHRINKFILE (N'DBNAME_log' , 11, TRUNCATEONLY)GO USE [master]GOALTER DATABASE DBNAME SET RECOVERY FULL WITH NO_WAITGOALTER DATABASE DBNAME SET RECOVERY FULL --还原为完全模式GO