sql server (alternate): Transaction log file too early to apply -- sql server (alternate)

Transaction log file too early to apply

watuni2000 NO[at]SPAM yahoo.co.nz
10/28/2004 7:18:04 AM

sql server (alternate):

Hi
I implement a manual standby by backing up Transaction log files every
hour
and database nightly and restoring these on a standby server.
Every thing works fine but the Transaction log restore fail with error
listed
I am sure the database backup finishes before the transaction log
backups

Thanks

TY

The log in this backup set terminates at LSN 22927000000763100001,
which is too early to apply to the database. A more recent log backup
that includes LSN 22927000000773700001 can be restored. [SQLSTATE

Re: Transaction log file too early to apply

watuni2000 NO[at]SPAM yahoo.co.nz
11/15/2004 8:59:34 AM

[quoted text, click to view]

I did stop truncating transaction logs before backing up the database
and every thing works as desired now