April 30, 2008 at 8:49 am
Hi All,
Logshipping and Replication setup on DR servers:
We have 3 servers which are on site A, A1, B1 and C1 with replication setup here
A1 is the production server (in this case with 2 databases), A1 is the publisher
B1 is the Distributor and Subscriber
C1 is also another subscriber.
This is the setup already setup on site A and working.
Now we want a DR for site A, We want the same setup as site A on the DR side(site B) with replication as being setup on site A.
so we want to setup another site B on remote location. Where we can synchronize our site A db’s using log shipping
We have created 3 servers on site B as, A2,B2 and C2
Now the issue is we want to setup logshipping from A1 to A2,
And setup replication between A2,B2 and C2.
Hence we need to make A2 as publisher, B2 as (distributor,subscriber) of A2 and C2 as subscriber of A2.
?’s
Can we do logshipping and replication like this?
What is the best way of doing this?
Site1 is working on cluster server with A1 as production, B1(active cluster) and C1(passive cluster), will this affect the process?
When we do logshipping from A1 to A2, A2 will be in restoring mode, Can we still do replication like that?
While doing replication, we need to create distributor and then from distributor we need to subscribe the publication for B2 and C2?
In a scene of DR, how fast we can bring the site B back on production in case of failover at site A and How?
Can we keep the site 2 on standby, and do this process?
Note: All servers are on sql server 2005 with sp2 on both site A and site B.
The whole idea of this process is to keep our site A replica to another location and the replication process running, so that in a case of DR we can restore back all the Db’s to the latest point of time with minimum downtime.
Thanks
April 30, 2008 at 9:56 am
Honestly, the best way is with a 3rd party app.
I use a program called Double Take. It does instant byte for byte replication at the hard drive level and is extremely easy to install and set up.
It is one of the very few ways to have a zero data loss DR plan that I've found.
April 30, 2008 at 10:25 am
Thanks
but do you have any suggestions without a third party tool.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply