问题:
当我们执行SQL语句或者存储过程时,报如下错误
Msg 9002, Level 17, State 2, Procedure delete_by_tis_code, Line 228
The transaction log for database 'APNAT' is full due to 'LOG_BACKUP'.
解决方案:
使用下面语句查看:
use master
GO
select log_reuse_wait_desc,log_reuse_wait from sys.databases WHERE name='apnat'