清除SQL日志

DUMP TRANSACTION [Site-SH-01] WITH NO_LOG
BACKUP LOG [Site-SH-01] WITH NO_LOG
DBCC SHRINKDATABASE([Site-SH-01])


ALTER DATABASE [Site-SH-01]
            SET RECOVERY SIMPLE;
            DBCC SHRINKFILE ([Site-SH-01_log], 1);
            ALTER DATABASE [Site-SH-01]
            SET RECOVERY full

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/cuiwenke/p/1834723.html