SQL2008数据库的日志清理 .SQL如下:
数据库名称 =DBName
USE [master]
GO
ALTER DATABASE DBName SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE DBName SET RECOVERY SIMPLE --简单模式
GO
USE DBName
GO
DBCC SHRINKFILE (N'DBName_Log' , 11, TRUNCATEONLY)
GO
USE [master]
GO
ALTER DATABASE DBName SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE DBName SET RECOVERY FULL --还原为完全模式
GO
-------------------------------------------------------------------
SQL2005数据库的日志清理 .SQL如下:
DUMP TRANSACTION 数据库名称 WITH NO_LOG
BACKUP LOG 数据库名称 WITH NO_LOG
DBCC SHRINKDATABASE( 数据库名称 )
-----------------------------------------------