May 1, 2014 at 2:54 pm
hi All,
I need some suggestions - I am supporting large number of Development and Test databases. Almost every day I get 50+ requests to restore the databases from Production to Dev or Test to Dev (replace or new both)
So, I want to write a generic script which can take care of restores requests. Please advise if someone has already experienced this situation and can share some experience.
Thanks in advance.
Regards
Sachin Diwakar.
May 1, 2014 at 3:06 pm
You can configure central management server (CMS). Add all your SQL Servers and write a dynamic script to restore.
May 2, 2014 at 12:26 am
Yes, you can create a job for RESTORE to execute it on demand.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply