mssqlserver 分日志（日志文件过大）

ALTER DATABASE HexStudyDB3Reader SET RECOVERY SIMPLE WITH NO_WAIT
ALTER DATABASE
HexStudyDB3Reader SET RECOVERY SIMPLE --简单模式

DBCC SHRINKFILE (N'HexStudyDB3Reader_log' , 1, TRUNCATEONLY)

ALTER DATABASE HexStudyDB3Reader SET RECOVERY FULL WITH NO_WAIT

ALTER DATABASE HexStudyDB3Reader SET RECOVERY FULL

posted on 2015-11-18 17:22  ddai  阅读(208)  评论(0)  编辑  收藏  举报