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?


  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
    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.

  4. techbabu303 New Member

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


Share This Page