SQL Server Performance

Mirroring/ clustering /replication

Discussion in 'SQL Server Clustering' started by techbabu303, Dec 18, 2006.

  1. techbabu303 New Member

    I was reviewing this interesting link about Disastor recovery strategies , I have some questions as listed below .

    1. Does this apply to SQL server 2005 ? Has there been improvements in each strategy in sql server 2005 ?

    2. About clustering is it necessary for both nodes to physicall present in same geographical location as the article suggests ?

    3. Database Mirroring , how many minutes or seconds will it take to fail over ? Also I had a impression it was for data protection not failover , can Anyone explain this or point to the link which shows Architecture and Implementation details of database mirroring?


    http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?topicid=1&faqid=97


    Cheers
    Sat
  2. satya Moderator

    1) There has been lot improvement in provision of high availibility in the case of SQL 2005 and you can check books online in this case.
    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/fa506f04-4bcf-42ed-a936-9f8d4418f1c0.htm fyi.

    3) ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/fdcf2251-9895-44c6-b81e-768fef32e732.htm


    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  3. techbabu303 New Member

    Thx....will check out the links u suggested.

    Cheers
    Sat
  4. techbabu303 New Member

    Somehow Iam not able to view the links you have mentioned Satya, do you have alternate links I can use.

    Cheers
    Sat

Share This Page