求助:转储日志失败?

shelleydragon

1>; dump tran szt to "/backup/sztlog_200408101200.dat"
2>; go
Msg 4207, Level 16, State 1:
Server 'p650a', Line 1:
Dump transaction is not allowed because a non-logged operation was performed on
the database. Dump your database or use dump transaction with truncate_only
until you can dump your database.

查看日志空间,没有问题,以前数据库一直是定时自动增量备份,这几天突然出现这样的问题,请指教.

ywtmh

你是不是进行过一些不记日志的操作？比如说select into,快速的BCP啊等等这些不记日志的操作，只要你先做个全库的备份再做日志备份应该就没问题了！