Partager via

Backup solutions for Exchange 2007...

  • Article

The continuous replication technology available in Exchange 2007 gives us some interesting new options for backing up Exchange data. I think the increasing number of options that are now available means that there will undoubtedly be more discussions and confusion about which strategy to choose so I thought I would try and work through at least some of the various options for the more common implementations.

For this first blog I will talk about the first of these 4 options which should be by far the easiest and doesn't require much explanation...  What follows is a very simple discussion of the solution.

Design 1 - Standalone Mailbox Role Servers

The first thing that I have to mention in the context of data protection is the importance of Service Level Agreements. Before we can even start designing a backup solution it is vital that we have a good understanding of what our recovery objectives are. We really need to try and pin down firstly whether Outlook is a critical application in terms of our ability to communicate via email (so can we use a dial-tone recovery?) and secondly whether the data held within our databases is critical to the business (so we need to plan for a standard database recovery?). If it is a yes to both then we need to understand how long our business can be without access to Outlook and our Exchange data. Ok so this is a very difficult exercise and if the business will not dictate this then we should be directing the business by coming up with a number ourselves and then obtaining their agreement on this. Once we've got a number, like (at its most basic) 4 hours to restore the full service including all data, then we have something to aim for...

(For the purposes of this blog I am going to assume that we do not have using any other replication technologies like SAN storage replication.  If we do this changes the discussion entirely as this will dictate how, when and what we back up.)

The main options are as follows:

  1. Traditional streaming backup to tape
  2. Traditional streaming backup to disk and then to tape
  3. Snapshot backups based on the Volume Shadow Copy Service

Traditional streaming backup to tape

This is the standard form of backup solution that all Exchange Administrators will be familiar with in some form or another.  This is possible through the ESE api and is supported by NTBackup and the new System Centre Data Protection Manager 2007 (DPM), as well as numerous 3rd party products from our partners.  There are a number of advantages and disadvantages to using traditional streaming backup to tape when you are using standalone mailbox role servers.  These are summarized as follows:

Advantages Disadvantages
Mature technology with numerous options in terms of software and hardware Will impact the performance of the server during the course of the backup so needs to be considered particularly with companies providing a 24 hour service
Can run backups against multiple storage groups concurrently (NTBackup would required multiple backup jobs to do this) Need to be aware of its impact on IS Maintenance.  Your backup window should be staggered to avoid the IS Maintenance period
Generally simple to setup Can be relatively slow, particularly when compared to VSS snaps or streaming backup to disk
  Can be relatively expensive in terms of the number of tapes that are required
  Full backup each night is generally recommended to be able to meet most recovery objectives (alternative could be weekly fulls and daily differentials)
  Often restricted to relatively small databases in order to meet our recovery SLA's

Traditional streaming backup to disk and then to tape

Very similar in terms of advantages and disadvantages above; the differences being that the speed of any backup is going to be faster, and therefore the impact of your backup on performance and IS Maintenance will be minimized.  Also it is likely that if you need to restore your database from last night it will most likely still be on disk and therefore offline restores to a new storage group then becomes an option (making use of database portability). (*Be careful with public folders though as these are not 'portable'.) Also a traditional restore from disk is likely to be relatively fast, especially when compared to a restore from tape.  The pro's and con's are as follows:

Advantages Disadvantages
Mature technology with numerous options in terms of software and hardware Will impact the performance of the server during the course of the backup so needs to be considered particularly with companies providing a 24 hour service
Can run backups against multiple storage groups concurrently (NTBackup would required multiple backup jobs to do this) Need to be aware of its impact on IS Maintenance.  Your backup window should be staggered to avoid the IS Maintenance period
Generally simple to setup Can be relatively slow, particularly when compared to VSS snaps**
Generally faster than streaming backups to tape** Can be relatively expensive in terms of the number of tapes that are required
  Full backup each night is generally recommended to be able to meet most recovery objectives (alternative could be weekly fulls and daily differentials or even incrementals)
  Often restricted to relatively small databases in order to meet our recovery SLA's
  Requires additional disk space

**The speed of your backup and restore will be determined by a number of factors including network, tape device, RAID type,backup software etc etc.. To give you an idea MSIT used to use NTBackup to back up there Exchange 2003 data to disk and then tape and achieved the following:

  • "Individual backup throughput per storage group can be sustained at approximately 1.2 GB per minute
  • Total throughput can be sustained at approximately 4.8 GB per minute per Exchange virtual server with four concurrent backups running.
  • Restore rates can be achieved in the range of 2 GB per minute for a disk-to-disk-based restoration. This throughput is achievable once the disks being written to are not under any form of production load."

This information was taken from a 'Note on IT' article.

Snapshot backups based on the Volume Shadow Copy Service

The third option which many administrators might not be so familiar with is to take snapshot, 'point in time' backups of your Exchange data.  Snapshots are supported to run against the active copy of a storage group although continuous replication does now enable us to offload snaps to the replica database  ...I'll come to that in another blog. Support for VSS has been in place since Exchange 2003 but in my experience has not been widely adopted. (Indeed NTBackup does not provide support for 'Exchange aware' snaps.)  VSS allows files to be backed up when they are still open essentially by pausing disk I\O.  On an Exchange Server a read only copy of the Exchange data is copied to disk which will typically take a couple of seconds and will almost imperceptibly interrupt Outlook. We can take snaps every hour for example and so will be able to restore to multiple points in time according to how many spans we take. A good explanation of how this works in detail can be found here. Exchange 2007 has improved support for VSS including, for example, the ability to restore VSS backups to alternative locations (database portability again) but the technology is essentially the same.

Again there are numerous partner products that can provide you with the ability to take snapshots but DPM is the product which I think will really interest administrators who want to re-evaluate their backup solution.

DPM's approach is described as follows:

"DPM uses a combination of transaction log replication and block-level synchronization in conjunction with the Exchange VSS Writer to help ensure your ability to recover Exchange 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 Exchange Server VSS Writer to identify which blocks have changed in the entire production database, and send just the updated blocks or fragments. This provides a complete and consistent image of the datafiles on the DPM 2007 server. DPM 2007 maintains up to 512 shadow copies of the full Exchange Server database(s) by storing only the differences between any two images.

Assuming one “express full” per week, stored as one of 512 shadow copy differentials between one week and the next, plus seven days x 24 hours x 4 (every 15 minutes), DPM 2007 provides over 344,000 data consistent recovery points for Exchange."

Using VSS obviously has a number of advantages and disadvantages:

Advantages Disadvantages
Might be able to eliminate or at least significantly reduce any reliance on tape based backups Recovering historical data from a point in time prior to my first snap means I need to retain my tape devices
Very fast backup (after the 1st) If I am mandated to keep data offsite I may need to retain my tape devices of replicate my backups offsite
Potentially very fast recovery Might require large amounts of additional disk space
Only one backup per storage group but with E2K7 a 1:1 ratio of databases:storage groups is recommended and you can run multiple vss snaps in parallel Often a little more complex to design and configure
Faster backup and recovery times means that databases can be larger so therefore fewer servers might be required  
IS Maintenance will not be interrupted as snaps taker far less time that traditional streaming backups  
Aside from the first full backup there is little performance impact for clients  
A solution like DPM means that control of most backups and recoveries is controlled by the messaging team and not by a separate team which can confuse and delay recoveries**  

**Depends on the solution that is deployed as to whether you can take advantage of this.

If you are deploying stand alone mailbox role servers and are not taking advantage of Exchange 2007's continuous replication technology, or its equivalents, then I believe there are still significant advantages to deploying VSS snaps with something like DPM, particularly when you consider that DPM can be deployed to protect much more than just your Exchange data in the same way.  However I think the decision will often depend on how critical your data recovery times are.  If they need to be fast then you might need to go VSS.  If not then dial-tone recovery and standard restore seems to be the most obvious recovery path.  In which case the choice is then between disk to disk or direct to tape.  My preference is disk to disk but then I'm not stumping up the money for the disks.  The more interesting choices come when you introduce continuous replication into the mix which I will discuss in my next blogs...

Design 2 - Standalone Mailbox Role Server with LCR enabled

....to follow.

Comments

  • Anonymous
    October 16, 2007
    PingBack from http://www.artofbam.com/wordpress/?p=9084

  • Anonymous
    December 14, 2007
    Where's the rest of this article?

  • Anonymous
    December 16, 2007
    Sorry - in draft but on the way...

  • Anonymous
    March 12, 2008
    Any update? Looks very useful article.

  • Anonymous
    September 23, 2008
    Doug: If I'm running E2K7 on W2K8 there is no native support for NTBackup because there is no the NTBackup utility in W2K8, so the option of streaming backup using NTBackup is not available in W2K8. I need to know if Microsoft will launch some low cost tool -other than DPM- to perform backups for E2K7 on W2K8 or we must tell to customer that they must purchase DPM or other thitd party  VSS compiant tool to backup E2K7 DBs? Kind Regards, JARQuito