re-sync log shipping database
I'm on my first day of log shipping - After several hours of successful shipping, I truncated the log on the main database (during sql maintenance, it was too big) and that broke the sync.
I'm getting this message now on the destination server:
NGB-WEB-02: Restore - Failed
Restoring transaction log backup - Failed
This operation failed with errors.
Restoring NGB01 (transaction logs) from:
C:\Program Files\Microsoft SQL Server\MSSQL\logShipping\LOG_ngb01_20081014203001.sqb
SQL Server error
SQL error 3013: SQL error 3013: RESTORE LOG is terminating abnormally.
SQL error 4305: SQL error 4305: The log in this backup set begins at LSN 933998000000001600002, which is too late to apply to the database. An earlier log backup that includes LSN 933996000007504800001 can be restored.
SQL Backup exit code: 1100
SQL error code: 4305
Updating SQL Server information - Pending
Is there any way to re-sync without deleting the entire job and recreating it? The DB is about 60 gb and takes a while to 'seed', I'd like to avoid that.