日志传送备份作业失败 [英] Log shipping Backup job failed
问题描述
我为四个数据库(SQL 2008r2)配置了日志传送,为两个数据库配置了LS作业成功运行。另外两个数据库备份作业失败,错误如下。
消息:
2014-05 -19 08:15:00.68 ***错误:服务器'SERVERNAmE'的备份失败。 (Microsoft.SqlServer.Smo)***
2014-05-19 08:15:00.71 ***错误:执行Transact-SQL语句或批处理时发生异常。(Microsoft.SqlServer .ConnectionInfo)***
2014-05-19 08:15:00.71 ***错误:无法执行BACKUP LOG,因为没有当前的数据库备份。
BACKUP LOG异常终止。(。Net SqlClient数据提供程序)***
我使用差异备份并应用它来继续日志链但第二天作业失败再次出现同样的错误。我观察了3天,但一次又一次失败。
注意:所有数据库都具有相同的配置。
请帮我这个。
谢谢,
Sree。
Hi,
I configured log shipping for four databases(SQL 2008r2) and for two databases the LS jobs are running successfully. Another two databases backup job was failed and the error is below.
Message:
2014-05-19 08:15:00.68 *** Error: Backup failed for Server 'SERVERNAmE'. (Microsoft.SqlServer.Smo) ***
2014-05-19 08:15:00.71 *** Error: An exception occurred while executing a Transact-SQL statement or batch.(Microsoft.SqlServer.ConnectionInfo) ***
2014-05-19 08:15:00.71 *** Error: BACKUP LOG cannot be performed because there is no current database backup.
BACKUP LOG is terminating abnormally.(.Net SqlClient Data Provider) ***
I took diff backup and applied on it to continue log chain but next day the job failed again with the same error.I observed for 3 days but it failed again and again.
NOTE:All the databases having the same configuration.
please help me on this.
Thanks,
Sree.
推荐答案
这篇关于日志传送备份作业失败的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!