MSSQL
红色字体esapp1为 要删除日志的数据库名称。
蓝色字体为 数据库日志文件名称
use ESApp1
alter database esapp1 SET REcovery simple with no_wait
alter database esapp1 set recovery simple
use ESApp1
dbcc SHRINKFILE(N'ESAPP1_LOG',0,TRUNCATEONLY)
USE master
ALTER DATABASE ESAPP1 SET RECOVERY FULL WITH NO_WAIT
ALTER DATABASE ESAPP1 SET RECOVERY FULL