March 26, 2009 at 9:48 am
I read in the Sql Server 2005 Implementation and Maintenance, book, "database mirroring allows a principal and mirror to occur only in pairs(for example, a principal cannot have more than one mirror, and vice versa)." Can you principal a database more than once, as long as you have a corresponding mirror?
Thanks,
DK
March 26, 2009 at 10:09 am
No, the primary database can be mirrored to only one destination database. For the configuration you refer to you will need to use Replication
March 26, 2009 at 10:13 am
Nope a Principal and a Mirror always form a pair. so, you cannot have multiple principals to a mirror or multiple mirrors to a principal unlike Log shipping where you can have multiple secondaries.
March 26, 2009 at 11:06 am
Thanks SA and Krishna.
March 26, 2009 at 11:20 am
No problem, you are Welcome 🙂
March 26, 2009 at 11:26 am
Really you are superb krishna:-D
[font="Comic Sans MS"]+++BLADE+++[/font]:cool:
March 26, 2009 at 11:28 am
http://msdn.microsoft.com/en-us/library/5h52hef8(VS.80).aspx
[font="Comic Sans MS"]+++BLADE+++[/font]:cool:
March 26, 2009 at 11:39 am
J.K (3/26/2009)
Really you are superb krishna:-D
Ohh thanks 🙂
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply