[备考] SQL (及以上) - 清空数据库日志

1 USE [master]2 GO3 4 ALTER DATABASE [DBName] SET RECOVERY SIMPLE WITH NO_WAIT5 GO6 7 ALTER DATABASE [DBName] SET RECOVERY SIMPLE --简单模式8 GO9 10 USE [DBName]11 GO 12 13 -- SELECT FILEID,GROUPID,NAME FROM SYSFILES WHERE GROUPID = 014 15 DBCC SHRINKFILE (N'SLTDB_log' , 11, TRUNCATEONLY) 16 GO 17 18 USE [master] 19 GO20 21 ALTER DATABASE [DBName] SET RECOVERY FULL WITH NO_WAIT22 GO23 24 ALTER DATABASE [DBName] SET RECOVERY FULL --还原为完全模式25 GO