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

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/ddddai/p/4975230.html