InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 05:11:08 GMT20http://www.sqlservercentral.com/Forums/Topic1211093-384-1.aspxThanks, AllWed, 23 Nov 2011 10:32:56 GMTspenn6367http://www.sqlservercentral.com/Forums/Topic1211093-384-1.aspx[quote][b]spenn6367 (11/23/2011)[/b][hr]Do you know if a back-door exists for said issue?[/quote]log shippingWed, 23 Nov 2011 10:12:15 GMTgeorge sibbaldhttp://www.sqlservercentral.com/Forums/Topic1211093-384-1.aspxIn 2008 a mirroring setup can only have one principal and one mirror. End of story.SQL 2012 (Denali) has AlwaysOn which allows for multiple active replicas. This is a new feature, it's not an enhancement to mirroring, SQL 2012 will still have the old mirroring feature as wellWed, 23 Nov 2011 10:02:30 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1211093-384-1.aspxDo you know if a back-door exists for said issue?Wed, 23 Nov 2011 08:53:15 GMTspenn6367http://www.sqlservercentral.com/Forums/Topic1211093-384-1.aspxNot until Denali gets released. Currently you can only have a single mirror. If you want two locations then you have to mirror to one and log ship to the other.Once Denali is released (as SQL 2012), then you will be able to mirror to up to 4 locations, but I believe they're now calling then replicas rather than mirrors.Wed, 23 Nov 2011 08:47:22 GMTAndeavourhttp://www.sqlservercentral.com/Forums/Topic1211093-384-1.aspxDoes anyone know if one database can be mirrored to two different locations with the generic database mirroring set up?Please advise.Wed, 23 Nov 2011 08:41:06 GMTspenn6367