April 23, 2014 at 12:18 pm
Hi
I have 2 server PROD n DR server all the PROD server DB is synched to DR server through log shipping. Now to chk whether the DR server is working or not in case of any disaster we shut down the PROD server now all the app request is handled by DR server,it is working fine. For 1 week we work in DR server now its time to move back to PROD server so that all the 1 week data in DR server should be replicate back to PROD server. Log shipping is deleted once the DR Server is up.
What r the options other than Backup? It is SQL 2012
April 23, 2014 at 12:35 pm
Since you are using SQL server 2012, you could do the complete set up using HADR. If you are using Log shipping then you have no other option than Back up and restore or setting Logshipping back to the original server.
-Roy
April 23, 2014 at 1:10 pm
Roy thanks for the reply
let suppose I am using Always on with Availability group for DR.
Then how to replicate back the data to PROD
April 23, 2014 at 1:34 pm
When you are using Availability Group set up, you just fail over to your secondary. The secondary becomes the primary and data will be replicated back by itself. So you dont need to do anything special. Look up setting up HADR and you will gets all the info you need.
-Roy
April 23, 2014 at 10:40 pm
Thanks roy let me check with this
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply