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