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

 

ALTER DATABASE DATATABLE SET RECOVERY SIMPLE

 

DBCC SHRINKFILE  (DATATABLE_Log, 1)

 

ALTER DATABASE DATATABLE SET RECOVERY FULL

 

 posted on 2021-11-02 21:09  絆τ  阅读(143)  评论(0)    收藏  举报