USE [master]
GO
ALTER DATABASE [BI] SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE [BI] SET RECOVERY SIMPLE --简单模式
GO
USE [BI-V2.0]
GO
DBCC SHRINKFILE (N'BI_log' , 11, TRUNCATEONLY)
GO
USE [master]
GO
ALTER DATABASE [BI] SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE [BI] SET RECOVERY FULL --还原为完全模式
GO
sql2008日志收缩
最新推荐文章于 2021-11-27 15:55:21 发布