Disaster Recovery Solutions for SQL Servers
If your company relies on Microsoft SQL Server to manage and deliver information or if you are deploying or migrating to SQL 2008, you can trust SQL Server Disaster Recovery Experts from LG Networks will help you to maximize its protection and recovery.
Microsoft SQL Server 2008 Always On Technologies provides a full range of options to minimize downtime and maintain appropriate levels of application availability.
- Database outages
- Performance problems
- Data Recovery
- Upgrade issues
Minimize downtime, speed up recovery, and achieve the appropriate level of availability defined by service level agreements.
- Increase availability by providing complete or nearly complete database redundancy in the event of a disaster or planned upgrade
- Provide a high-availability solution that does not require proprietary hardware, is easy to set up and manage, and provides automatic client redirection
- Protect against page corruption by using SQL Server 2008 Enterprise to automatically fetch the mirror version of a corrupt page from a partner server
- Use log shipping to provide database-level redundancy with two or more instances of SQL Server by automatically backing up, copying, and restoring transaction logs on standby servers
- Increase availability by providing multiple failover sites
- Apply a time delay for applying transaction logs on the standby server to provide protection against user errors
- Reduce the load on the primary server by using a secondary server for read-only query processing
- Provide server-level redundancy on a certified Microsoft Cluster Services configuration
- Enable seamless fail-over capabilities in the event of a CPU, memory, or other non-storage hardware failure by sharing disk access between nodes and restarting SQL Server on a working node in the event of a failure
Geographically Dispersed Fail-over Clustering
Provide server-level redundancy and remove the single point of failure in a typical failover cluster by using a certified Microsoft Geographically Dispersed Cluster Services configuration with SAN replication and a VLAN
- Replicate changes at close to real time while all databases also handle their primary responsibilities
- Increase scalability, availability, and processing capacity by configuring applications to use different peers and to fail over to another peer in the event of a peer failure
- Protect against accidental conflicts with SQL Server 2008 conflict detection
- Increase availability by dynamically adding a new node to an existing topology
- Easily visualize and manage your topology with the Topology Viewer in SQL Server 2008
Enhanced Backup and Restore
- Use mirrored backup sets to perform a concurrent backup of a database to multiple backup devices and to increase protection in the event of backup media failure
- Create checksums on backup media to verify subsequent restore operations
Checksum on Data Pages
- Detect damaged database pages quickly, regardless of how the damage occurred, by using checksum on data pages
- Detect pages that were written incompletely, or from outside of SQL Server, and use online page-level restore to replace the faulty page
Using Microsoft System Center Data Protection Manager
Microsoft System Center Data Protection Manager (DPM) is designed for the Database Administrator and uses wizards and workflows to help ensure that you can protect your data.
DPM protects SQL Server databases every 15 minutes, but can restore not only to each of those 15-minute marks, but also enable administrators to recovery to any transaction point, or even to the very latest committed transaction following an outage.
How does Microsoft DPM protect SQL Server?
Data Protection Manager (DPM) uses a combination of transaction log replication and block-level synchronization in conjunction with the SQL Server VSS Writer to help ensure your ability to recover SQL Server databases. After the initial baseline copy of data, two parallel processes enable continuous data protection with integrity:
Transaction logs are continuously synchronized to the DPM server, as often as every 15 minutes. An “express full” uses the SQL Server VSS Writer to identify which blocks have changed in the entire production database, and sends just the updated blocks or fragments. This provides a complete and consistent image of the data files on the DPM server or appliance. DPM maintains up to 512 shadow copies of the full SQL Server database(s) by storing only the differences between any two images.
Now you can back up your SQL Server with Data Protection Manager 2010. See DPM 2010.
SQL Server Disaster Recovery Experts from LG Networks
Our SQL Server Disaster Recovery Professionals are certified SQL Server Consultants who have managed and recover numerous SQL Servers across the country for countless clients. As part of the Disaster Recovery Consulting Services, our highly-skilled SQL Server Disaster Recovery Specialists have access to exclusive training and information through the Microsoft Gold Certified Partner program. Call us at 866-808-7705 so we can give you a free assessment.