Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2011

    Unanswered: SQL 2008 R2 Mirroring as High Availability and disaster Recovery between 2 sites

    What would be the best HA and DR solution for SQL 2008 R2 Enterprise( 2 Instances) each hosting 100 and 50 databases respectively.

    Current Hardware Software :
    OS = Windows 2008 r2 Enterprise
    Ram = 16 G

    Is mirroring the best option?
    Is there any limitation on the amount of database that can be mirrored?


  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    Mirroring is good for High Availability and some forms of Disaster Recovery.
    Do not RELY on Mirroring for Disaster Recovery. It is not a substitute for backing up databases and logs.
    Scenario: a faulty or poorly written ad-hoc process accidentally deletes the records in one of your tables. Since the delete is mirrored, you can't recover this data in any way except from backups.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

  3. #3
    Join Date
    Jul 2003
    San Antonio, TX
    150? It's not as many as I've seen, but it is definitely a prime candidate for a specific concern, - make sure to implement asynchronous!
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts