February 17, 2015 at 3:15 am
Hi All
My Log Shipping restore job failed with the following error:
Could not redo log record (13023:2295024:1), for transaction ID (0:0), on page (9:80880), allocation unit 6488064, database 'DB' (database ID 5). Page: LSN = (13023:2294964:5), allocation unit = 6488064, type = 11. Log: OpCode = 5, context 11, PrevPageLSN: (13023:2294935:41). Restore from a backup of the database, or repair the database
I decided to check the backup and restore history on the primary and secondary servers.
There seems to be a problem because according to the restore history, there are a few transaction logs that was restored but these is no history of these log backups every being done on the primary server. Make sense?
Any ideas?
Thanks
February 17, 2015 at 4:39 am
my temptation here would be to just reinitialise the LS plan once I've confirmed the Primary is healthy
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 17, 2015 at 4:45 am
Perry Whittle (2/17/2015)
my temptation here would be to just reinitialise the LS plan once I've confirmed the Primary is healthy
Thanks
I am in the process of reinitializing with a full backup.
I'm just confused as to what exactly happened here
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply