none
SQL 2008r2 Mirroring on 2 servers RRS feed

  • Question

  • I plan to have 2 identical servers (SQL1 & SQL2) used for production.  I have 2 databases (DB1 & DB2).   To get full utilization of the hardware, I want to make the SQL1 server the principal for DB1 and SQL2 the mirror for DB2.  SQL2 server will be the mirror for DB1 and the principal for DB2.

    I will have a third server (WITNESS1) as the witness server for both as I want to run in full protected.  Is this scenario possible?  What are the PRO's or CON's in this situation?

    Thursday, December 2, 2010 5:40 PM

Answers

  • The scenario is possibe for sure. It's a good solution for high availability if you applications support database mirroring. There are two Cons that I see with this:

    1) There is no automatic failback in mirroring, so no easy way to ensure that you have one database active per server at all the time. If the mirror flips over for whatever reason it will stay there as long as nothing triggers it to flip back.

    2) As I said, it's only a good solution if your applications support mirroring...

    Lucifer

    Friday, December 3, 2010 6:35 AM

All replies

  • The scenario is possibe for sure. It's a good solution for high availability if you applications support database mirroring. There are two Cons that I see with this:

    1) There is no automatic failback in mirroring, so no easy way to ensure that you have one database active per server at all the time. If the mirror flips over for whatever reason it will stay there as long as nothing triggers it to flip back.

    2) As I said, it's only a good solution if your applications support mirroring...

    Lucifer

    Friday, December 3, 2010 6:35 AM
  • I would like to add to Lucifer's suggestions

    1. Mirroring database  will not be avaialble to query till  you create a snapshot database

    2

    .http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx -----Mirroring(Best Practices)
    http://blogs.msdn.com/sqlcat/archive/2009/02/09/minimize-downtime-with-db-mirroring.aspx ----Mirroring


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Monday, December 6, 2010 9:55 AM