jjturner (8/5/2014)
Is it possible to RESTORE WITH MOVE and subsequently RESTORE the remaining backup chain (DIFF's and LOG's) to the new location?I'm getting this error when I try to RESTORE the DIFF after RESTORE WITH MOVE on the FULL:
[font="Courier New"]Msg 3136, Level 16, State 1, Line 2
This differential backup cannot be restored because the database has not been restored to the correct earlier state.[/font]
From what you say, it sounds as if you didn't use the WITH NORECOVERY clause in your original RESTORE statement. Please post your RESTORE statements if that isn't the case.
You don't need to make sure the database is not in use when backing up - SQL Server handles open transactions during recovery.
John