SQL Server 2005 Database Mirroring Setup 1

[bdc101]

I have two questions:

1) Can one instance of sql server on a third server be the mirror for instances on multiple servers, i.e. database x on server x and database y on server y both have a mirror on server z?
2) A separate license is not required for the secondary instance if it is used solely for mirroring purposes. Does that still hold true is database x needs to failover but database y does not?

 

[mrdenny]

Yes you can mirror from two servers to a third server.

If you mirror from server1 and server2 to server3 and server3 is the mirror for all the databases then no license for server3 is needed.

If all databases from server1 failover to server3 the license would go with it. If some databases from server1 failover to server3 and some don't then you'll need a license for server3. If you fail everything back there's some grey area you can work with.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP

My Site