正文
去sqlserver日志
提示：扫一扫查出行【扫一扫了解最新限行尾号】
复制提示
USE [master]
GO
ALTER DATABASE DNName SET RECOVERY SIMPLE WITH NO_WAIT GO ALTER DATABASE DNName SET RECOVERY SIMPLE --简单模式 GO
USE DNName GO DBCC SHRINKFILE (N'DNName_Log' , 11, TRUNCATEONLY) GO
USE [master]
GO ALTER DATABASE DNName SET RECOVERY FULL WITH NO_WAIT
GO ALTER DATABASE DNName SET RECOVERY FULL --还原为完全模式 GO
