Home About Us Services Training Resources Clients Contact
Services
Server Deployment
Upgrade & Migration
High Availability
Disaster Recovery
Development
Business Intelligence
Security
Performance Tuning
Maintenance
Remote DBA
Database Auditing
Evaluate - License
Capacity Planing
Tool Implementation
Change Management
Project Management
Others

 
SQL Square SQL Server High Availability Solutions 
Overview

In today’s, competitive marketplace, it is very important for any business to remain available to their clients and in many cases, it is 24x7. The availability of 99.5% is considered a basic availability these days as you loose 43.8 hours in a year. Refer to Availability Matrix.

SQL Server Failover Cluster

Microsoft SQL Server 2005 and 2000 have a number of features to improve the availability of your database environment, which essentially drives the business environment in this digital age. High Availability and Fault-tolerance are related but different things. Fault-tolerance is a mechanism to achieve the 100% availability. But achieving fault-tolerance in individual sub-systems (e.g. redundant power supplies, RAID, redundant paths to storage, clustered servers, redundant network connections and so on), we can make the overall system highly available or even better 99.999% fault-tolerant.

Standby SQL Server using Log Shipping
Our Approach
  • Understand your availability requirements
  • Evaluate the available solutions with respect to your requirements and environment
  • Choose the best solution that fits your requirements and budget
  • Implement the solution
  • Monitor and maintain the solution

SQLSquare High Availability & Fault-Tolerance is implemented by our certified DBAs who plan, install and configure a high availability / Fault-tolerant solution to fit your requirements. The variety of solutions is based on SQL Servers features like Log Shipping (Stand-by Server), Database Mirroring, Fail-over Cluster, Active-Active Cluster and other technologies.

Our SQL Server High Availability expertise
  • Microsoft Clustering Services (MSCS) on Windows 2003 Platform
  • Microsoft Clustering Services (MSCS) on Windows 2000 Platform
  • Other Third Party Clustering & High Availability Solutions
  • Stand-by Server using Log Shipping
  • Database Mirroring
SQL Server Active/Active Cluster Database Mirroring using SQL Server 2005
Key Benefits
  • Provide near continuous access to data with minimal interruption by hardware and software component failure
  • Quickly and automatically recover Server failures and resume services without having to wait for repairs to be made to the failed node 
  • Your database can survive disasters, human errors, corruptions and other planned or unplanned outages that can otherwise incapacitate a database
Availability Matrix
  • If your System availability is 99.5%, you lose 43.8 hours in a year!
  • If your System availability is 99.9%, you lose 8.78 hours in a year!
  • If your System availability is 99.99%, you lose about 53 minutes in a year!
  • If your System availability is 99.999%, you lose about 6 minutes in a year!

Contact SQLSquare today!