How can we help you today? How can we help you today?

log shipping restore job failure after few successful runs

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
Zaven.Aharonian
0

Comments

1 comment

Sort by
  • 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.
    petey
    0

Add comment

Please sign in to leave a comment.