sql server 日志满解决方法

USE [OA]
GO
ALTER DATABASE OA SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE OA SET RECOVERY SIMPLE --简单模式
GO
USE OA
GO
DBCC SHRINKFILE(N'OA_Log' , 11, TRUNCATEONLY)
GO
USE[OA]
GO
 
ALTER DATABASE OA SET RECOVERY FULL WITH NO_WAIT
 
GO
 
ALTER DATABASE OA SET RECOVERY FULL  --还原为完全模式
 
GO