What are the challenges you face when working across database platforms? Take the survey
Options

log shipping restore job failure after few successful runs

Zaven.AharonianZaven.Aharonian Posts: 2
edited December 14, 2014 9:18PM in SQL Backup Previous Versions
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

Comments

  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.