Differential not restoring

  • I've got a test machine that I'm using. I'll just be wrapping these tests into the benchmarking tests that I'm already running so not a huge deal.

  • Just to update:

    The filegroup backup is indeed part of the backup chain, so restoring that and then restoring the differential backup made the restore happy.

    However, the DB refused to fully recover. I got a bunch of errors about LSN's being out of sequence and filegroups not existing that it expected to have. Not sure what's up with that. I had to dump that DB so I could do some testing on other matters but I will be pursuing this matter.

    Will keep everyone posted.

  • Using the COPY_ONLY option on the filegroup backup works. Restore from Full then Differential backup went just fine. No idea where the errors on the other restore process happened but I dont plan to spend much time on that. I've got a few more tests I want to run but it looks like all is good.

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply