Re: Mirroring a DB to multiple servers
- From: "Tom Moreau" <tom@xxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 29 Aug 2008 15:09:51 -0400
No, you can't. If you want to have multiple copies of a DB, consider
log-shipping or peer-to-peer replication.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Aaron" <Aaron@xxxxxxxxx> wrote in message
news:eklPRGgCJHA.3268@xxxxxxxxxxxxxxxxxxxxxxx
We are currently running SQL server 2005 on two servers. One server is in
head office, and the other one is in the Disaster Recovery site. I'm using
SQL Mirroring to mirror the databases in the head office to the SQL server
in the DR site, and it works fine. My question is: Can I mirror the
databases on the head office SQL server to a third server? In other words,
can I have the Principle database mirrored to Two other mirror servers?
.
- References:
- Mirroring a DB to multiple servers
- From: Aaron
- Mirroring a DB to multiple servers
- Prev by Date: sql server 2005 install does not start
- Next by Date: RE: How to disable password policy with install command option of
- Previous by thread: Mirroring a DB to multiple servers
- Next by thread: sql server 2005 install does not start
- Index(es):
Relevant Pages
|
