清除SQL日志
2010-09-25 17:16 CuiWenKe 阅读(234) 评论(0) 编辑 收藏 举报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