log shipping error

[djj55]

Hello, In SQL 2000 after trying several options, I am still having problems with log shipping. It worked for several months okay then started having errors. Example:

[Microsoft SQL-DMO (ODBC SQLState: 42000)]
Error 4305: [Microsoft][ODBC SQL Server Driver][SQL Server]
The log in this backup set begins at LSN 700821000002125700001, which is too late to apply to the database. An earlier log backup that includes LSN 700821000002120800001 can be restored.
[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE LOG is terminating abnormally.

Here is the setup.
[ol A]
[li]do a fullbackup of ten databases on primary server at 9 PM nightly. Example:

BACKUP DATABASE [master] TO DISK = N'D:\SQL_BACKUP\MASTER_BACKUP' WITH  INIT ,  
        NAME = N'master backup',  SKIP ,  NOFORMAT

[/li]
[li]setup log shipping with monitor server[/li]
[ol i]
[li]When setting up the destination database I use the same location for Transaction Log Destination Directory as local and as a share (imputing \\share\)
[/li]
[li]Have tried using the last full backup and preforming a full backup
[/li]
[li]Set backup schedule and copy/load to same increment with zero load delay (have played with the between time but do not know if I have it correct using both all day and stop before backup).
[/li]
[/ol]
[/ol]
Suggestions?

Thank you,
Dana

 

[mrdenny]

The error that you are getting tells you that you are missing a log backup in the sequence. You need to find the missing log backup and let SQL Server restore that one, or take a full backup and restore that full to the receiving server and start moving the logs again.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog

 

[djj55]

Thank you for the reply.

Does the full backup of the primary database cause problems for the log shipping?

Thank you,
Djj

 

[mrdenny]

No you can do full backups of the source database without effecting the log shipping.

You need to make sure to not do a log backups of the source database other than the ones that the log shipping is doing. You should also make sure that you don't change the database recovery mode as that will require that you restore the full to the backup server again.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog