log shipping restore job failure after few successful runs
Zaven.Aharonian
Posts: 2
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
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
Comments
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.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8