清除SQL日志
时间:2010-09-25 来源:CuiWenKe
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
相关阅读 更多 +