sql server 清除日志

DB_PY_Product：数据库名称，以下替换

USE [master]

GO

ALTER DATABASE [DB_PY_Product] SET RECOVERY SIMPLE WITH NO_WAIT

GO

ALTER DATABASE [DB_PY_Product] SET RECOVERY SIMPLE --简单模式

GO

USE [DB_PY_Product]

GO

DBCC SHRINKFILE ('DB_PY_Product_log' , 11, TRUNCATEONLY)

GO

USE DB_PY_Product

GO

SELECT file_id, name FROM sys.database_files

GO

USE [master]

GO

ALTER DATABASE DB_PY_Product SET RECOVERY FULL WITH NO_WAIT

GO

ALTER DATABASE DB_PY_Product SET RECOVERY FULL --还原为完全模式

GO