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?

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" wrote in message
news:eklPRGgCJHA.3268@TK2MSFTNGP03.phx.gbl...
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?

If you are comfortable with playing around with scripts, you can create a
custom-log shipping solution as this is just a simple backup-restore
process. Just remember though that this is not something Microsoft supports
but as long as you are doing the process correctly, you're good to go. Check
out this blog entry on how you can create one
http://bassplayerdoc.blogspot.com/2007/10/your-poor-mans-sql-server-log-shipping...

"Tom Moreau" wrote in message
news:Oic#nrgCJHA.2056@TK2MSFTNGP05.phx.gbl...