Click here to Skip to main content
15,887,464 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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.
Posted
Updated 19-May-14 3:39am
v2
Comments
karthik Udhayakumar 19-May-14 19:09pm    
Hey Sree,
Check if the DB's are set as read-only.
SreeDBA 20-May-14 2:35am    
Hey Karthy,
The DB not in read_only mode.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900