SQL 日志太大,脚本清除
摘要：-收缩日志 USE [master] GO ALTER DATABASE mydatabase SET RECOVERY SIMPLE WITH NO_WAIT GO ALTER DATABASE mydatabase SET RECOVERY SIMPLE --简单模式GO USE mydatabaseGO DBCC SHRINKFILE (N'mydatabase_Log' , 11, TRUNCATEONLY) GO USE [master] GO ALTER DATABASE mydatabase SET RECOVERY FULL WITH NO_WAIT GO AL
阅读全文
posted @
2012-10-18 08:52
micenter
阅读(497)
推荐(0) 编辑
