SQL Server High Availability/Fault Tolerance.

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

Hi all,

Currently we have the following setup:

2 Node Active/Passive SQL Server 2000 Enterprise Ed. Cluster,running on
Windows 2003 Enterprise Ed. Single production database,about 1.5 GB in
size,growing rate is about 150 MB per month.
The shared storage is on HP EVA 5000.The 2 servers and SAN are all in the
same room.
Both hardware and software upgrade are planned for the near future. Key
points are High Availability and Fault Tolerance.
SQL Server 2005 Standard or Enterprise Edition is considered as the DB
software because large portion of the business logic is implemented in
complex Stored Procedures,making use of T-SQL.
After the upgrade 2 separate buildings will be used. At each location we are
planning to have 1 SAN and 2 SAN switches,servers, tape libraries and
Ethernet switches. SAN and Ethernet switches in the 2 buildings will have
connections between them,the distance is about 100 metres. Possible choice
for SAN is the NetApp FAS 3050C model,which is advertised to have software
solutions for copying data between SAN's.
I am doing a research on the High Availability/Fault Tolerance/Disaster
Recovery solutions for the SQL Server database.
Is there any solution providing automatic Failover even in the event of
complete SAN failure(for exapmle in the event of fire or earthquake)
,assuming that we have 1 SQL Server and SAN in each buiding and 1 of the
buildings remains intact ?

Any help will be greatly appreciated.

Regards






.

Relevant Pages

  • Re: SQL Server High Availability/Fault Tolerance.
    ... Node Active/Passive SQL Server 2000 Enterprise Ed. Cluster,running on Windows 2003 Enterprise Ed. ... SQL Server 2005 Standard or Enterprise Edition is considered as the DB software because large portion of the business logic is implemented in complex Stored Procedures,making use of T-SQL. ... At each location we are planning to have 1 SAN and 2 SAN switches,servers, tape libraries and Ethernet switches. ... you can now use Database Mirroring. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server High Availability/Fault Tolerance.
    ... be very carefull with using the term "Fault tolerance" ... The shared storage is on HP EVA 5000.The 2 servers and SAN are all in the ... SQL Server 2005 Standard or Enterprise Edition is considered as the DB ... After the upgrade 2 separate buildings will be used. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
    ... Our san guy is ... completely forget about is that moving the head on the disk is the slowest ... the drives that were being assigned to the SQL machine. ... I mean the binn folder which contains the sql server executable among ...
    (microsoft.public.sqlserver.setup)
  • Re: Maybe the Records Are There After All
    ... Run DBCC UPDATEUSAGE to correct the row count display in Enterprise Mangler. ... Senior Database Administrator ... I support the Professional Association for SQL Server ... > Enterprise Manager and it gave me the sensation that ALL of the data had ...
    (microsoft.public.sqlserver.server)
  • Re: Replace SSMS 2005 with SSMS 2008
    ... I also posted that I was able to install SQL Server 2008 Enterprise ... Evaluation Edition if it were installed as this edition. ... Can you try to install a SQL Server 2008 Enterprise Edition on a Vista or XP ...
    (microsoft.public.sqlserver.tools)