I'm setting up log shipping and am running into an issue with applying the transactions logs.
This is my 5th server that I'm setting up and I take a backup of the source database, restore it with replace on the standby server. Then I take a log backup, copy it over and try and restore on the standby server, but the LSN#'s are off. It tells me it's too late for the log and try an earlier..
The timestamp on my backup is 11:43 and my translog was at noon...
I ran a checkpoint on the source database, but that didn't seem to do anything.
What am I missing
Thanks
Susan
Standby Restore
calle81
MarlAtkins
I know this will probably sound stupid, but the database isn't in simple recovery
You could also check the backup history in msdb.
MPWhizz
A few things:
1. As Don said, did you restore the db WITH NORECOVERY and/or WITH STANDBY on the standby server
2. Did you do anything to break the LSN chain inbetween making the backup and applying it What activity did you do inbetween 11:43 and 12PM
3. Did you accidentally restore the wrong full backup