USE [master]
GO
ALTER DATABASE szcg SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE szcg SET RECOVERY SIMPLE --简单模式
GO
USE szcg
GO
DBCC SHRINKFILE (N'szcg_Log' , 11, TRUNCATEONLY)
GO
USE [master]
GO
ALTER DATABASE szcg SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE szcg SET RECOVERY FULL --还原为完全模式
GO
清理SQL Server数据库日志
最新推荐文章于 2024-07-24 10:20:18 发布