Trying to apply a .Bak, a .Dif, then .trn for a restore a prod Database to a TEST server & database
The .BAK goes fine
The .dif is giving me fits, with the attached message.
This is the 1st time I've tried a SQL restore with queries.
I issued these commands:
RESTORE DATABASE P21TEST
FROM DISK = '\sql1\Backup\P21\P21_backup_2016_02_04_222133_6470682.bak'
MOVE 'seed16_data' TO 'G:\SQL\DATA\P21TEST.mdf',
MOVE 'seed16_log' TO 'G:\SQL\DATA\P21TEST_Log.ldf',
Then, I tried:
RESTORE LOG P21TEST FROM DISK = '\\sql1\Backup\P21\P21_backup_2016_02_05_120004_8203734.dif' WITH NORECOVERY
I keep getting:
Msg 4305, Level 16, State 1, Line 16
The log in this backup set begins at LSN 1044747000000001600137, which is too recent to apply to the database. An earlier log backup that includes LSN 1044211000000028500001 can be restored.
Msg 3013, Level 16, State 1, Line 16
RESTORE LOG is terminating abnormally.