各位菜鸟,还为数据库庞大的日志烦恼么,请用下面的语句清理你的数据库吧~
--清理数据库日志USE [master] GO ALTER DATABASE RMS3P4 SET RECOVERY SIMPLE WITH NO_WAIT GO ALTER DATABASE RMS3P4 SET RECOVERY SIMPLE --简单模式 GO USE RMS3P4GO 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