SELECT NAME, recovery_model_desc FROM sys.databases --查看数据库的模式

     ALTER DATABASE TOMS SET RECOVERY SIMPLE WITH NO_WAIT

     GO

     ALTER DATABASE TOMS SET RECOVERY SIMPLE   --简单模式

     GO

     USE TOMS

    GO

     DBCC SHRINKFILE ('TOMS_log' , , TRUNCATEONLY)

     GO

     USE [master]

     GO

    ALTER DATABASE TOMS SET RECOVERY FULL WITH NO_WAIT

    GO

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

    GO