各位菜鸟,还为数据库庞大的日志烦恼么,请用下面的语句清理你的数据库吧~
--清理数据库日志
USE [master]
GO
ALTER DATABASE RMS3P4 SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE RMS3P4 SET RECOVERY SIMPLE --简单模式
GO
USE RMS3P4
GO
DBCC SHRINKFILE (N'RMS2_Log' , 11, TRUNCATEONLY)
GO
USE [master]
GO
ALTER DATABASE RMS3P4 SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE RMS3P4 SET RECOVERY FULL --还原为完全模式
GO