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清除数据库日志已满
最新推荐文章于 2024-02-05 12:22:33 发布