SQL Server High Availability
How long can your business afford to operate without its mission critical applications?
SQL Server High Availability is the technology which provides resilience to your database systems, allowing them to remain online and available 24x7. Your SQL Server databases are the back-bone of your business and life blood or your business intelligence systems and as such, outages and downtime can become very costly, very quickly.
Contact UniverSQL to discuss the range of SQL Server High Availability options available to you. Whether you require geographically dispersed SQL Server Disaster Recovery solutions, or onsite multi-node SQL Server Clusters, our experienced consultants can setup, configure and performance tune the right SQL Server High Availability solution to meet with the specific needs, requirements and budget of your business.
In designing your SQL Server High Availability solution, UniverSQL will perform a comprehensive analysis of the following key factors which will influence the types of solutions most suitable to you;
- Configuration of current Production and Disaster Recovery Server Roles
- Suitability for Virtualisation
- Assessment of Network connectivity for remote SQL solutions
- Existing SQL Backup Configuration
- Executive level consultation in order establish Business Objectives and Requirements
- Consultation with Key Application Developers in order to establish any Known Issues
- Server Hardware review to establish suitability for SQL Server High Availability solution
- Executive level consultation in order establish Disaster Recovery Requirements
Once a final solution has been designed and agreed upon, UniverSQL will undertake the following tasks toward implemention of this;
- Installation, Configuration and Tuning the chosen solution in accordance with Microsoft Best Practice
- Testing and Analysis of System Logs to ensure no errors are encountered
- Documentation of the solutions including instructions on failover and recovery procedures
- Final consultation to ensure solution has met with the specified business requirements
SQL Server High Availability Solutions
SQL Server 2005
SQL Server 2005 "Always on" Technologies include database snapshots, log shipping, database mirroring, peer-to-peer replication, failover clustering, snapshot isolation and online maintenance operations. Used separately or in combination, these features help minimize downtime and keep your critical enterprise systems online and available to your business.
SQL Server 2008
SQL Server 2008 extends the above by including the following new features;
- Corrupted page recovery through enhanced database mirroring features
- Failover clustering enhancements in Microsoft SQL Server 2008 and Windows Server 2008
- Dynamic addition of new nodes to a peer-to-peer replication solutions
- Faster restore times
- Native backup compression (reduced disk space requirements)
- Improve concurrency with lock management enhancements
- Control workload prioritizations with Resource Governor
Downloads
SQL Server 2008 Failover Clustering White Paper
SQL Server 2005 Failover Clustering White Paper