清空日志
DUMP TRANSACTION DataBaseName WITH NO_LOG
截断事务日志
收缩数据库
DBCC SHRINKDATABASE(DataBaseName, {NOTRUNCATE | TRUNCATEONLY })
删除日志: DataBase->Properties->Files->Log->Initial Size
清空日志
DUMP TRANSACTION DataBaseName WITH NO_LOG
截断事务日志
收缩数据库
DBCC SHRINKDATABASE(DataBaseName, {NOTRUNCATE | TRUNCATEONLY })
删除日志: DataBase->Properties->Files->Log->Initial Size