清除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