Log Shipping Restore Error

moospot

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.

petey

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.