Sql Server2014数据库清理日志
Sql Server2014数据库日志占用特别大,清理方法。直接贴代码
USE[master] GO ALTER DATABASE db_Name SET RECOVERY SIMPLE WITH NO_WAIT GO ALTER DATABASE db_Name SET RECOVERY SIMPLE --简单模式 GO USE db_Name GO DBCC SHRINKFILE (N'db_Name_log' , 11, TRUNCATEONLY) GO USE[master] GO ALTER DATABASE db_Name SET RECOVERY FULL WITH NO_WAIT GO ALTER DATABASE db_Name SET RECOVERY FULL --还原为完全模式 GO