MEDIA数据库名
ALTER DATABASE MEDIA SET RECOVERY SIMPLE WITH NO_WAIT
ALTER DATABASE MEDIA SET RECOVERY SIMPLE --简单模式
DBCC SHRINKFILE (N'MEDIA_Log' , 11, TRUNCATEONLY) -- 11是大小 11M
ALTER DATABASE MEDIA SET RECOVERY FULL WITH NO_WAIT
ALTER DATABASE MEDIA SET RECOVERY FULL --还原为完全模式
转:http://blog.csdn.net/hehe520347/article/details/48497229