Sqlserver清除数据库日志已满
USE [库名]
GO
ALTER DATABASE [库名] SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE [库名] SET RECOVERY SIMPLE --简单模式
GO
USE [库名]
GO
DBCC SHRINKFILE (N’日志库名_log’ , 11, TRUNCATEONLY)
GO
USE [master]
GO
AL...
原创
2019-08-15 14:08:27 ·
256 阅读 ·
0 评论