SQL Server 日志文件大小清零 2008-12-16

backup log dbName with NO_LOG
backup log dbName with TRUNCATE_ONLY
DBCC SHRINKDATABASE(dbName)

 

以上方式仅限于SQL 2005以前版本

 

SQL 2008 则要使用以下新方式:

 

 

USE DatabaseName
GO

-- Truncate the log by changing the database recovery model to SIMPLE.

ALTER DATABASE DatabaseName SET RECOVERY SIMPLE

GO

-- Shrink the truncated log file to 10 MB.

DBCC SHRINKFILE (DatabaseLogFileName, 10)
GO

-- Reset the database recovery model.

ALTER DATABASE DatabaseName SET RECOVERY FULL