清理数据库日志文件

–查询日志名称
SELECT file_id, name FROM sys.database_files;

USE [master]
GO
ALTER DATABASE STEDI_Project SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE STEDI_Project SET RECOVERY SIMPLE
GO
USE STEDI_Project
GO

DBCC SHRINKFILE (N’FE_Project_log’ , 0,TRUNCATEONLY)
GO
USE [master]
GO
ALTER DATABASE STEDI_Project SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE STEDI_Project SET RECOVERY FULL
GO

USE STEDI_Project
GO
SELECT name FROM SYS.database_files WHERE type_desc=‘LOG’