SQL2008 的收缩日志&log日志丢失恢复

   USE[master]
   GO
    ALTER DATABASE MyDataBase SET RECOVERY SIMPLE WITH NO_WAIT
    GO
    ALTER DATABASE MyDataBase SET RECOVERY SIMPLE   --简单模式
    GO
    USE MyDataBase 
    GO
    DBCC SHRINKFILE (N'DataBase_Log' , 300, TRUNCATEONLY)
    GO
    USE[master]
    GO

    ALTER DATABASE MyDataBase SET RECOVERY FULL WITH NO_WAIT

GO

ALTER DATABASE MyDataBase SET RECOVERY FULL  --还原为完全模式

--log日志丢失恢复

alter database contentdb1 set emergency
alter database contentdb1 set single_user with rollback immediate
alter database contentdb1 rebuild log on (name=ContentDB1_log, filename='E:\mssql\contentdb1log.ldf')
ALTER DATABASE contentdb1 SET MULTI_USER with rollback immediate