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
    techbabu303, Dec 18, 2006
    #2

  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.
    satya, Dec 18, 2006
    #2

  3. techbabu303 New Member

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

    Cheers
    Sat
    techbabu303, Dec 18, 2006
    #2

  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
    techbabu303, Dec 18, 2006
    #2

Share This Page