sql2008日志收缩

来源:互联网 发布:office mac 2016 编辑:程序博客网 时间:2024/05/16 19:28
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


原创粉丝点击