log shipping restore job failure after few successful runs

Zaven.Aharonian

I configured log shipping with server 2 as a source using the option of manually restoring database and putting it in read only mode on .
It went successfully.
All log backups complete successfully.

The first two restores went fine but then start failing with the following error:

Date 12/10/2014 9:02:00 AM
Log Job History (SQL Backup log shipping job for database prd_db created 12/10/2014 8:07:38 AM)

Step ID 1
Server UKENTDB01
Job Name SQL Backup log shipping job for database prd_db created 12/10/2014 8:07:38 AM
Step Name execute master..sqlbackup
Duration 00:00:16
Sql Severity 16
Sql Message ID 50000
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: NT AUTHORITYSYSTEM. SQL Backup failed with exit code: 790 SQL error code: 4305 [SQLSTATE 42000] (Error 50000). The step failed.

There a currently few backups waiting to be processed and there are no other processes running on this db.

Any recommendations to resolve this.

Thank you.


Zaven

petey

Could you please post the contents of the SQL Backup log file for the restore process that failed?

SQL Backup generates a log file for each process that it runs. The default folder where the logs are stored is C:Documents and SettingsAll UsersApplication DataRed GateSQL BackupLog<instance name> on Windows 2003 and older, and C:ProgramDataRed GateSQL BackupLog<instance name> on Windows Vista and newer.