Post reply

High availability Question

  • February 2, 2017 at 9:54 am

    #318547

    can anyone tell me what is the best way/approach to get the following request done and it should be nightly refresh. Thanks!

    To get the 2 user databases which are in SIMPLE recovery model from  Production: SQL instance to Test SQL instance and they should get refreshed on TEST machine every nightly.
           
    Thanks in advance!

    -S

  • February 6, 2017 at 12:10 pm

    #1926939

    Agnii - Thursday, February 2, 2017 9:54 AM

    can anyone tell me what is the best way/approach to get the following request done and it should be nightly refresh. Thanks!

    To get the 2 user databases which are in SIMPLE recovery model from  Production: SQL instance to Test SQL instance and they should get refreshed on TEST machine every nightly.
           
    Thanks in advance!

    -S

    Is this really for HA or is this just a regular refresh from Production. This sounds like a regular refresh which can be automated using the last full backup from Production. You can manually do the refresh and keep track of everything you had to do in a script. From there, you should have an idea of what you need to do and be able to build a refresh job.

    Sue

  • February 7, 2017 at 10:02 pm

    This was removed by the editor as SPAM

Viewing 3 posts - 1 through 2 (of 2 total)

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