You just failed over from one data center to another – how much data are you really going to lose? Can you get any of it back? You’ll role-play a scenario from Hurricane Sandy using simple pieces of paper and see exactly how aftermath recovery really works.

3 Comments. Leave new

  • Hi Brent. It seems that Temporal/SystemVersioned tables help you resolve some of the questions you ask in this video? I recognize that SystemVersioned tables didn’t exist yet at the time of this video was made because you reference SQL Server Vnext coming out soon.

    Reply
    • It would still be left up to you to version all of your tables ahead of time, and then build a tool to merge all of that data together across multiple servers. That is not a trivial thing.

      Reply
  • I agree it is still hard. I just was thinking that System Versioned tables give you something more to work with than tables with no or little change history in them at all. But, you’re right. The System Versioned tables still have to be queried to get which versions happened when and the business still needs to make decisions about what to do with what is found from those queries.

    Reply

Leave a Reply

Your email address will not be published.

Fill out this field
Fill out this field
Please enter a valid email address.