Stretch

• MVDBA (Mike Vessey)

  SSC-Insane

  Points: 21797

  More actions

  November 20, 2019 at 12:09 pm

  #3699156

  Hi

  I'm looking to alleviate some storage issues until we get new hardware. I'm looking at stretch for a few archive tables that we need to keep but never update

  my question is if we lost our on premise server and need to do a restore maybe missing 15 minutes of data, is there an easy way of re-linking the stretch to the main DB.. or do we have to download the data and re-stretch it?

  MVDBA

• DinoRS

  SSCrazy

  Points: 2683

  More actions

  November 20, 2019 at 1:40 pm

  #3699183

  Hey,

  there's this rather good article about reauthorization of a Stretch DB, you have a few options regards the parts in the cloud with sp_rda_reauthorize_db

  Hope this helps