SQL Server 2005 Log Shipping Query

Hi,

I have setup Log Shipping with SQL Server 2005 for my company's PRD database. Everything works fine till 6:30 AM of the next morning. At 6:30 AM the Log Shipping job fails with the error (*** Error: BACKUP LOG cannot be performed because there is no current database backup).

Does this mean that I have to configure the job for doing full database backup daily in morning followed by Log Shipping process. Please clarify.

I am using the Transaction Log Shipping tool in SQL Management Studio to configure Log Shipping. I did not find an option to backup the full database daily in there. The Log shipping process backs up the full database only once in the beginning.

Also why the jobs fails exactly at 6:30AM daily. Any particular reason for this because it is not yet 24 hours after configuring the job.

Thanks

Praveen



Answer this question

SQL Server 2005 Log Shipping Query

  • SQL Server 2005 Log Shipping Query