sqlserver2008 清空日志文件

USE [master]
GO
ALTER DATABASE u3cdb_jy126 SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE u3cdb_jy126 SET RECOVERY SIMPLE --简单模式
GO
USE u3cdb_jy126
GO
DBCC SHRINKFILE (N'u3cdb_jy126_log' , 11, TRUNCATEONLY)

GO

USE [master]
GO
ALTER DATABASE u3cdb_jy126 SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE u3cdb_jy126 SET RECOVERY FULL --还原为完全模式
GO

 

通过以下命令查看数据库对应的日志文件名

SELECT file_id, name FROM sys.database_files;