MSSQL2008数据库压缩

来源:互联网 发布:细说php第四版pdf 编辑:程序博客网 时间:2024/05/22 15:01
USE [master]GOALTER DATABASE DNName SET RECOVERY SIMPLE WITH NO_WAITGOALTER DATABASE DNName SET RECOVERY SIMPLE   --简单模式GOUSE DNName GODBCC SHRINKFILE (N'DNName_Log' , 11, TRUNCATEONLY)GOUSE [master]GOALTER DATABASE DNName SET RECOVERY FULL WITH NO_WAITGOALTER DATABASE DNName SET RECOVERY FULL  --还原为完全模式GO

0 0