恢复模式:完整日志. 包括 Alwayson
--select size/128 as size_MB,* from sys.database_files f
backup log dbName to disk=N'NUL'
dbcc shrinkfile(2,0)
恢复模式:简单模式
--清空日志
DUMP TRANSACTION dbname WITH NO_LOG
--截断事务日志
BACKUP LOG dbname WITH NO_LOG
dbcc shrinkfile(2,0)