January 4, 2007 at 2:07 pm
Is it possible to setup two mirrors for a given principal.
January 4, 2007 at 2:51 pm
From BOL 2005:
How many destination servers do you require?
If you require only a single destination database, database mirroring is the recommended solution.
If you require more than one destination database, *you need to use log shipping*, either alone or with database mirroring. Combining these approaches gives you the benefits of database mirroring along with the support for multiple destinations provided by log shipping.
------------------------------------------
So if you were planing to use mirroring (only). The answer is *no*.
Hope that helps.
Cheers,
* Noel
January 4, 2007 at 6:47 pm
Why do you need two mirrors...
MohammedU
Microsoft SQL Server MVP
January 5, 2007 at 10:27 am
Mohammed,
I am trying to design a solution for high availability (HA) and disaster recovery (DR). We have two production database servers and two database servers, each for HA & DR.
Initial thought process was to have DB mirroring for HA (in house) and DB replication for DR. Then the question is in case of a disaster, how are the transactions going to be transferred from production to DR database server? (I know it's part of the day's work that would be lost).
So the next question was is it possible to have two mirrors one for HA & one for DR.
Is it true that SQL Server DB replication isn't a reliable solution for DR?
January 5, 2007 at 5:03 pm
For HA you can go with Mirroring or cluster
For DR: you can go with LOG shipping and there are some third party tools/sw available...
http://www.microsoft.com/events/series/technetsqlserver2005.mspx#HighAvailabilityDisasterRecovery
MohammedU
Microsoft SQL Server MVP
January 8, 2007 at 9:05 am
Why do you think log shipping is better than replication. Can you name some third party tools?
Thanks.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply