Re: Truly High Available?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Clustering, in and of itself, won't give you a geographically dispersed Highly Available Solution.

SQL 2005 offers Mirroring, which allows for a second system with automatic failover. There are also some third-party solutions that allow for geographically dispersed clusters. It is important to learn about the requirements and the capabilities of each technology to see what it can and cannot protect against. HA is not a technology-only solution. It requires People and Process to make it happen.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP



"acmcdba68" <acmcdba68@xxxxxxxxxxx> wrote in message news:B923F632-D8F9-43F1-A175-B20019259C89@xxxxxxxxxxxxxxxx
I have a scenerio where I must implement a Highly Available environment
between two locations seperated by 25 miles.

The premise is to create a solution that will keep our application up and
running if our main location were hit by a tornado, an auto failover would
take place to the remote location.

If using a Microsoft Clustered solution, how is it truly 'HA' if there is a
shared disk sub-system? If there is a tornado in Loc 'A' and the shared disk
resides there, what have I accomplished? The same goes for Loc 'B'?

Maybe I'm reading more into it but would like someone to shed some light on
this.
--
Anthony E. Castro

.

Relevant Pages

  • Re: Ongoing purging of active records causes deadlocks
    ... As for the clustering of the tables ... And CreateDate is typically now? ... on SQL 2000 the only deadlock priorties are LOW and NORMAL. ... We can try the clustered index, but i'm NOT convinced why this is ...
    (comp.databases.ms-sqlserver)
  • Re: Clustering for Performance
    ... clustering for SQL 7.0. ... Server scales up very well. ... Senior Database Administrator ...
    (microsoft.public.sqlserver.clustering)
  • Re: Choosing correct high availability setup
    ... normal SQL startup, DB integrity check, roll back non-committed ... MVP - Windows Server - Clustering ... Basically there will be an Access database that arrives via FTP at ...
    (microsoft.public.sqlserver.clustering)
  • Re: active/passive cluster vs log shipping
    ... So assuming I could remote in, what other benefits do clustering provide me ... over log shipping? ... > Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.clustering)
  • Re: Side-by-side upgrade - moving master, msdb and model
    ... MVP - Windows Server - Clustering ... "In some cases, you may want to copy the system databases, including ... from the source SQL Server 2000 instance to the SQL ...
    (microsoft.public.sqlserver.clustering)