Question

如何清除sql server日志

Answer 1

USE P2PDTSB

select * from sys.database_files--查看日志名称

USE [master]

ALTER DATABASE P2PDTSB SET RECOVERY SIMPLE WITH NO_WAIT

ALTER DATABASE P2PDTSB SET RECOVERY SIMPLE --简单模式

USE P2PDTSB

DBCC SHRINKFILE (N'P2P_log' , 12, TRUNCATEONLY)--日志名是表sys.database_files里的name值

USE [master]

ALTER DATABASE P2PDTSB SET RECOVERY FULL WITH NO_WAIT

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