我的数据库是数据库在线增加事务.如果日志将满，该怎么办? [英] My databse is database is online increasing transcation.if log will full then what to do ?

问题描述

我的数据库将满，然后在线就可以做??
数据库是MSSQL ...

My database will full which is online then to do ??
database is MSSQL...

推荐答案

使用以下sql命令(将dbname更改为您的数据库名称):

Use the following sql commands (change the dbname to your datatbase name):

dbcc shrinkfile(dbname_log,1)

backup log dbname with truncate_only

dbcc shrinkfile(dbname_log,1)

如果我建议，请通读以下文章关于SQL Server中的事务日志及其截断 [ ^ ]

If I may suggest, please read through the following article About transaction log and its truncation in SQL Server[^]

这篇关于我的数据库是数据库在线增加事务.如果日志将满，该怎么办?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！