5 Features You Need in Backup Software for Microsoft Exchange and/or SQL Server
By Ben Maas, DCIG, Sept. 30, 2013, 3:06 p.m.
Over the years both Microsoft Exchange and SQL Server have gotten the reputation (well-earned, I might add) of being difficult to backup and recover. Yet with the vast majority of all size companies running one if not both of these applications in their environments, using backup software that can effectively protect and recover these applications is no longer optional – it is a prerequisite. To ensure a company is effectively performing these tasks, here are five features backup software must offer to protect and recover Microsoft Exchange and/or SQL Server.
Independent studies confirm what many organizations suspect to be true: Microsoft Exchange and SQL Server are found in almost every business. According to Microsoft, Exchange has more than a 78 percent share of insourced email in businesses with more than 25 seats. Likewise, SQL Server has an equally commanding presence as it is used in as much as 83 percent of businesses. While these percentages may be a bit inflated as they come from Microsoft or Microsoft-friendly publications, there is little dispute that these two applications are widely deployed in businesses.
Despite their wide adoption, the ability to protect and recover these applications has never been easy. Ever since their initial release both Microsoft Exchange and Microsoft SQL Server have had a reputation for being difficult to backup and recover.
- First, when backing up or recovering this application data, it is an “all-or-nothing” proposition. Since the backup software cannot natively “see” email messages, email mailboxes, indices or tables inside these applications, it cannot just backup or recover items that have changed – it has to backup or recover the entire database of these applications.
- Second, the application must stop until the backup is complete. If the application is running while a backup is occurring and data changes, the backup copy may not be restorable. The only way to create a recoverable backup is to stop the application in its entirety until the backup completes.
- Support for Microsoft Volume Shadow Copy Service (VSS). Microsoft Volume Shadow Copy Service (VSS) does all the heavy lifting of achieving application consistency for these programs without the backup software needing to know the internals of either Exchange or SQL Server to back them up. By integrating with VSS, the backup software can invoke VSS. VSS prompts Microsoft Windows to acquiesce Exchange or SQL Server so the backup software can do a complete backup of either of these applications without incurring any application downtime.
- Flexibility to restore individual databases and emails. Exchange data stores can range from tens of gigabytes up to tens of terabytes and larger. Being forced to recover an entire data store would be both extremely time consuming and it may not be recoverable.To avoid either of these scenarios, backup software that supports Exchange and/or SQL Server must be able to achieve database and data store consistency and the safest way to achieve this consistency is through using VSS. VSS knows about the internal structure of these data stores on Microsoft Windows so it can retrieve more detailed information from within the data store. This is how solutions such as Eversync leverage VSS to backup and restore individual Exchange email messages or SQL Server tables.
- Synthetic full backups. Before synthetic full backups, administrators had to backup all of their data on a regular basis to tape and then do smaller backups in between (incremental backups.) If data needed to be recovered they first had to restore their last full backup, then each incremental until they reached the point in time they needed. Synthetic full backups eliminate this problem. When a synthetic full backup job is first created, solutions such as Eversync create a full backup of the data. From that point forward only the data that is changed or different is backed up (differential backups.) Eversync recognizes which versions of the data are associated with which snapshot. In this way when restores are needed the proper data can be retrieved immediately rather than being forced to do restores of data from multiple different backups.
- Data deduplication and compression. Deduplication takes all the parts of data that are the same and only keeps a single copy of that data, while compression removes unneeded space in the data. The more uniform your data, the bigger the savings in storage capacity. Solutions such as Eversync use both block deduplication and compression to greatly reduce the amount of data that gets stored to disk. Exchange and SQL Server are well suited to block deduplication as their respective database structures contain large amounts of redundant data as well as large amounts of empty spaces that are reserved by these respective applications.
- User friendly interface. An often overlooked aspect of backup software is a well-designed user interface, especially for small and medium sized businesses. Users in these shops are often IT generalists who have neither the time nor the inclination to pull out the manual every time they need to use the product. Eversync does a good job helping users visualize what data has been backed up, where it is and how to retrieve it if necessary. A web based user interface is typically the best suited for businesses as most users are now web-savvy.