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
ALTER DATABASE [库名] SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE [库名] SET RECOVERY FULL
Sqlserver清除数据库日志已满
最新推荐文章于 2023-01-13 12:01:17 发布