收缩数据库

USE[master]
     GO
     ALTER DATABASE MarketingSystem20171024 SET RECOVERY SIMPLE WITH NO_WAIT
     GO
     ALTER DATABASE MarketingSystem20171024 SET RECOVERY SIMPLE   --简单模式
    GO
     USE MarketingSystem20171024 
     GO
     DBCC SHRINKFILE (N'MarketingSystem_log' , 11, TRUNCATEONLY)
     GO
     USE[master]
     GO
    ALTER DATABASE MarketingSystem20171024 SET RECOVERY FULL WITH NO_WAIT
    GO
    ALTER DATABASE MarketingSystem20171024 SET RECOVERY FULL  --还原为完全模式
    GO