September 4, 2008 at 4:54 pm
I Have Two sites , site1 and site2
site one has two servers A and B and DB Mirroring is happening in two.
now i want to build Disaster Recovery plan on site2 for Site1 that has servers C and D for site1 which will work same like A and B servers , parallel I also want to use Site 2 site as Pre-production Environment.
what is the best way to do that without clustering .
September 5, 2008 at 3:19 am
I think you're mixing some concepts. Clustering is actually multiple servers around a database, where one server is active and the other is passive (waiting for the active server to crash :w00t: )
Mirroring is duplicating data to another location, what you're actually doing. You can setup a witness server with mirroring whichs reroutes database connections to the mirrored database in case of a failure on the primary (your A en B database) See BOL
The mirrored database is in a recoverystate and can't be accessed directly (i thought you could read it with a snapshot, not sure) so changes on this database is not possible. if you wan't some pre-productions actions in a production environment :hehe: you might consider (2-way) replication.
Wilfred
The best things in life are the simple things
September 5, 2008 at 5:21 pm
sorry for confusion actually
for production A to C Logshipping will work and i am thinking of separate instances for Pre-production on C and D and as per requirement i need to set up DB Mirroring from C to D for pre-production instances as well, i cant setup Log shipping and Mirroring for Pre-prod from A or B as i need Pre-prod C instance available for updates as well.
as of now i am thinking of weekly restore of production backups on pre-prod C instance and turn on Mirroring for D pre-prod instances ,any better solution with less admin. tasks?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply