SQL lower environment restore schedules

Question

Post reply

SQL lower environment restore schedules

rodto3rd

SSC Veteran

Points: 217
More actions
May 16, 2016 at 8:08 am

#310645

Currently I have inherited production, stage, qa and dev SQL environments. I am seeing what others have in place for restoring the lower environments and the schedules?
So for stage, have log shipping to have the most current data. QA on x schedule and DEV on x schedule.
Just seeing what others have configured.
Thanks.

Viewing 5 posts - 1 through 4 (of 4 total)

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

Summer90 SSC-Dedicated Points: 32891 More actions · Answer 1

Everyone is going to be different. I don't have any environment setup to keep data in sync 24X7.

I have SQL Agent jobs setup to backup and restore to Non Prod whenever the apps folks want the data refreshed.

Tava SSCarpal Tunnel Points: 4122 More actions · Answer 2

rodto3rd (5/16/2016)
Currently I have inherited production, stage, qa and dev SQL environments. I am seeing what others have in place for restoring the lower environments and the schedules?
So for stage, have log shipping to have the most current data. QA on x schedule and DEV on x schedule.
Just seeing what others have configured.
Thanks.

As mentioned above, have SQL Agent jobs configured for automated refreshes.

Our environment is PROD -> UAT -> TST -> DEV.

UAT - I do regular weekly refreshes which is as simply as Scheduling the Job. In the steps I have tasks such as kill connections, restore DB, creates users / assign permissions, hashes data etc.

TST / DEV - this is not scheduled but on demand from testers / developers. I generally rarely restore these environments as a lot of work is going on.

Whatever works in your environment - stick to it.

rodto3rd SSC Veteran Points: 217 More actions · Answer 3

Thanks guys...this is generally what I was looking for. Just to see what others are currently doing.

Thanks!

Summer90 SSC-Dedicated Points: 32891 More actions · Answer 4

rodto3rd (5/17/2016)
Thanks guys...this is generally what I was looking for. Just to see what others are currently doing.
Thanks!

Simply use the GUI for the restore and click on generate script. Put that and any alter login, grant logins into that script and you have everything you need to refresh an environment.