Mirroring/ clustering /replication | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Mirroring/ clustering /replication

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?
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.
Thx….will check out the links u suggested. Cheers
Somehow Iam not able to view the links you have mentioned Satya, do you have alternate links I can use. Cheers