清理数据库日志

SQL2005、SQL2000

--清空日志
DUMP TRANSACTION Test WITH NO_LOG

--收缩数据库文件
DBCC SHRINKFILE ('Test',1) 

--截断事务日志
BACKUP LOG Test WITH NO_LOG

SQL2008

USE [master]
GO

ALTER DATABASE [Test] SET RECOVERY SIMPLE WITH NO_WAIT
GO

ALTER DATABASE [Test] SET RECOVERY SIMPLE
GO

USE [Test]
GO

DBCC SHRINKFILE (N'Test_log',10,TRUNCATEONLY)
GO

USE [master]
GO

ALTER DATABASE [Test] SET RECOVERY FULL WITH NO_WAIT
GO

ALTER DATABASE [Test] SET RECOVERY FULL
GO