更改成simple类型
ALTER DATABASE ASFCORE SET Recovery simple
收缩日志文件大小(单位是M)
DBCC SHRINKFILE (N’ASFCORE_log’ , 10)
检查日志文件名称
USE ASFCORE
SELECT NAME, size FROM sys.database_files
恢复成FULL类型
ALTER DATABASE ASFCORE SET Recovery FULL
更改成simple类型
ALTER DATABASE ASFCORE SET Recovery simple
收缩日志文件大小(单位是M)
DBCC SHRINKFILE (N’ASFCORE_log’ , 10)
检查日志文件名称
USE ASFCORE
SELECT NAME, size FROM sys.database_files
恢复成FULL类型
ALTER DATABASE ASFCORE SET Recovery FULL