ALTER DATABASE EICJT SET RECOVERY SIMPLE --将“恢复模式”设置为“简单” GO USE EICJT GO DBCC SHRINKFILE (N'EIC_log' , 1, TRUNCATEONLY)--收缩日志文件大小到1M EIC_log 在sys.database_files里查到,以这里为准 GO USE EICJT GO ALTER DATABASE EICJT SET RECOVERY FULL WITH NO_WAIT ----将“恢复模式”设置为“完整” GO ALTER DATABASE EICJT SET RECOVERY FULL GO
select * from sys.database_files --查询dbname