backup log 数据库名称 with no_log
dbcc shrinkfile (数据库日志文件逻辑名称)
例如:
backup log database1 with no_log
dbcc shrinkfile (database1_log)
backup log 数据库名称 with no_log
dbcc shrinkfile (数据库日志文件逻辑名称)
例如:
backup log database1 with no_log
dbcc shrinkfile (database1_log)