Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

2 copies of mirroring database Expand / Collapse
Author
Message
Posted Wednesday, June 25, 2014 8:38 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 21, 2014 9:06 AM
Points: 124, Visits: 451
Hi guys,
is it possible ABC database on server 1 mirror on server 2 and server 3? another word can I configure mirroring of the same database to 2 different servers ( 2 copies)?
Post #1585934
Posted Wednesday, June 25, 2014 11:07 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 11:59 AM
Points: 594, Visits: 933
Nope. Mirroring is a single Principal and a single Mirror. Other options would be replication, log shipping, SAN tools (replication, etc).



Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1586016
Posted Thursday, June 26, 2014 7:35 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 21, 2014 9:06 AM
Points: 124, Visits: 451
Thanks for your input.
Post #1586429
Posted Thursday, June 26, 2014 9:12 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, October 31, 2014 4:01 PM
Points: 835, Visits: 1,192
Or if you are using SQL Server 2012/2014 Enterprises Edition, you can have multiple readable replicas with Always on.
Post #1586510
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse