Can someone figure out what i am doing wrong for this restore attempt or tell me if my backup files are jacked.
I am trying to recover a database from backups. I am grabbing the backup files from our network share
and attempting to recover on my laptop.
laptop has a full install of sql 2012.
1) i am able to restore the full backup file and keep it in the non recovery state.
2) when i try to apply the differential backup on the recovering state full, it gives me the error. "there is a break in the lsn chain"
in the picture provided. "pic1.jpg"
can someone confirm that by just looking at the lsn chain values, that the backups seem to be ok?
black square has the full back up file
red square has the differential back up file that fails.