如果当前数据库为完整模式,则需先将其改为简单模式
use AlertSystem
ALTER DATABASE AlertSystem SET Recovery Simple
DBCC SHRINKFILE (N'AlertSystem_log' , 1, TRUNCATEONLY)
ALTER DATABASE AlertSystem SET Recovery FULL
use AlertSystem
ALTER DATABASE AlertSystem SET Recovery Simple
DBCC SHRINKFILE (N'AlertSystem_log' , 1, TRUNCATEONLY)
ALTER DATABASE AlertSystem SET Recovery FULL