LG Networks, Inc.

SQL Server Disaster Recovery Solutions

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.

Our team of experienced SQL Server Disaster Recovery Professionals are able to quickly and efficiently resolve SQL Server problems such as:
  • Database outages
  • Performance problems
  • Data Recovery
  • Upgrade issues

Increased Availability

Minimize downtime, speed up recovery, and achieve the appropriate level of availability defined by service level agreements.

Database Mirroring

  • 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

Log Shipping

  • 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

Fail-over Clustering

  • 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

Peer-to-Peer Replication

  • 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.

Exit mobile version