February 2, 2017 at 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
February 6, 2017 at 12:10 pm
Agnii - Thursday, February 2, 2017 9:54 AMcan 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