--设置简单恢复模式 ALTER DATABASE [DB_Data] SET RECOVERY SIMPLE; GO DBCC SHRINKFILE ([DB_Data_log], 1); GO --恢复为原模式 ALTER DATABASE [DB_Data] SET RECOVERY FULL; GO