Solved

DB Mirroring / Auto-Failover Questions

Posted on 2010-08-16
2
458 Views
Last Modified: 2012-05-10
[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.
0
Comment
Question by:bamapie
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 12

Accepted Solution

by:
Máté Farkas earned 500 total points
ID: 33452762
1. Yes it is true. But if you use SQL Native Client for connecting to mirroring session this is no problem (one database from SQL1 another from SQL2). In any case you can use a trick to fail over other databases automatically: http://www.mssqltips.com/tip.asp?tip=1564
2. One Wittness server can inspect multiple servers and multiple mirroring sessions if you configured it. So yes, you can use SQL3 wittness to controls fail over between SQL4 and SQL2.
0
 

Author Closing Comment

by:bamapie
ID: 33454633
Beautiful
0

Featured Post

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question