<div>
<div class="content wysiwyg-content">
[SQL Server 2008]<br />
<br />
These are goofy questions, I'm sure, but I want to be positive.<br />
<br />
Picture SQL1 and SQL2 are my principal and mirror servers. &nbsp;SQL3 is the witness.<br />
<br />
(1) &nbsp;Mirroring is database-by-database, which I love. &nbsp;But just to make sure, if my witness server sees that DB1 is no longer responsive on SQLL1, it will only fail over *DB1*, right?<br />
<br />
In other words, so if I have DB1 and DB2 on SQL1, both mirrored to SQL2...if I take DB1 offline, the failover is only scoped to DB1, right? &nbsp;My applications that request DB2 are still going to use SQL1, right? &nbsp;And DB2's requests are then routed to SQL2?<br />
<br />
(2) &nbsp;Now picture ANOTHER sql box. &nbsp;It's SQL4, and it just has SharePoint 2010 or something on it.<br />
<br />
Now, I also want to mirror DBs on this box to SQL2...so that if SQL4 goes south, my SQL3 witness server will still work for this relationship.<br />
<br />
So, that witness box will need to monitor DBs between SQL1 and SQL2, but also between SQL4 and SQL2.<br />
<br />
Will it do that? &nbsp;Seems too good to be true.<br />
<br />
Thanks.<br />

</div>
</div>


[SQL Server 2008]

These are goofy questions, I'm sure, but I want to be positive.

Picture SQL1 and SQL2 are my principal and mirror servers.  SQL3 is the witness.

(1)  Mirroring is database-by-database, which I love.  But just to make sure, if my witness server sees that DB1 is no longer responsive on SQLL1, it will only fail over *DB1*, right?

In other words, so if I have DB1 and DB2 on SQL1, both mirrored to SQL2...if I take DB1 offline, the failover is only scoped to DB1, right?  My applications that request DB2 are still going to use SQL1, right?  And DB2's requests are then routed to SQL2?

(2)  Now picture ANOTHER sql box.  It's SQL4, and it just has SharePoint 2010 or something on it.

Now, I also want to mirror DBs on this box to SQL2...so that if SQL4 goes south, my SQL3 witness server will still work for this relationship.

So, that witness box will need to monitor DBs between SQL1 and SQL2, but also between SQL4 and SQL2.

Will it do that?  Seems too good to be true.

Thanks.


DB Mirroring / Auto-Failover Questions

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.