Resotore Log backup- Replication

• SQLRO

  SSCrazy

  Points: 2923

  More actions

  March 16, 2009 at 6:02 am

  #384135

  Hi,

  We have SQL Server 2000 database. We take full back up once in the night and log backup after every hour.

  I am trying to restore the full backup on SQL Server 2005 which gets restored successfully but while restoring log backup it gives the following error

  Server: Msg 4305, Level 16, State 1, Line 1

  The log in this backup set begins at LSN 36138000007098100001 which is too late to apply to the database. An earlier log backup that includes LSN 36138000006401500001 can be restored.

  Even if the log backup is taken just 15 minutes after full backup it gives the same error.The database is in Full recovery mode.

  The database is also a subscriber as well as publisher under transactional replication.

  What must be the reason for this error?

  Thanks in advance.

  Regards,

  Rohit

• GRE (Gethyn Ellis)

  SSCrazy Eights

  Points: 9602

  More actions

  March 16, 2009 at 7:30 am

  #960208

  could be somthing to do with the sync with backup option, haven;t done too much with replication but this maybe a place to start....

  http://msdn.microsoft.com/en-us/library/ms151224.aspx

  Gethyn Elliswww.gethynellis.com