Log Shipping Restore Error

moospotmoospot Posts: 2
edited June 19, 2006 10:00PM in SQL Backup Previous Versions
Hi. I'm new to SQL Backup and I just set it up to use log shipping. The main server backups are fine, but the standby server reports this error whenever I try to run the restore job. I've looked all over for error code 4326, but I can't seem to find anything about it. The sqltech account is a domain admin, a sys admin on both sql servers and has full control of the network share folder. The SQL Server and Agent are running under this account.
Summary
The job failed.  The Job was invoked by User sa.  The last step to run was step 1 (Step 1).

Step 1
Executed as user: PREMIER\sqltech. SQL Backup job failed with exitcode: 0  SQL error code: 4326 [SQLSTATE 42000] (Error 50000).  The step failed.
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    SQL error code 4326:
    The log in this backup set terminates at LSN %.*ls, which is too early to apply to the database. A more recent log backup that includes LSN %.*ls can be restored.

    You could copy the script from the job step, then run it manually from Query Analyzer/SSMS, to determine which file contains data that's too early to apply to the database.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.