【SQL】数据库日志文件过大 4条命令删除日志

USE DATATABLE GO

 

ALTER DATABASE DATATABLE SET RECOVERY SIMPLE

 

DBCC SHRINKFILE  (DATATABLE_Log, 1)

 

ALTER DATABASE DATATABLE SET RECOVERY FULL