Exchange 2010 - What is the simplest safe way to backup the database so transaction logs truncate?

Posted on 2012-08-18
Last Modified: 2012-08-18
My understanding is that an "application aware" backup must be done on a MS Exchange database in order to trigger MS Exchange to truncate transaction logs. Right now the database resides on the C drive, which is the system volume. I read this article that recommends a full server backup.
I don't want to buy an expensive Exchange backup program, but I would like to avoid backing up the entire C drive. The only possibility I can guess at is using some sort of Windows command to make Exchange commit/truncate the log files and then use Windows Backup to perform a file-level backup of the database folder. The solution I propose was not recommended by anyone online, so I suspect it is not safe.
I am willing to write scripts and scheduled tasks if necessary.
Question by:jjh2010

    Author Comment

    By the way, I find on Server 2003 running Exchange 2007 there is a way to select Microsoft Exchange while making a Windows seems odd that a similar customization to 2008's backup wizard is not available.
    LVL 52

    Assisted Solution

    by:Manpreet SIngh Khatra
    You need to take backup from Exchange aware as Online Backup :)

    Exchange 2007 Online Backup

    Brick Level Backups are one of the worst things you can inflict on your Exchange Server. They are old technology, which as stated above, is slow and virtually useless.

    I would recommend you look into a product like Symantec Backup Exec (with the Exchange Agent) for performing online, Exchange-aware backups of the Information Store. If you ever had to restore said backups, you can easily make use of a Recovery Storage Group - an accepted method of Exchange data recovery.

    The built-in NTBACKUP (in Server 2003) should also be able to back-up your Information Store. If you are using Server 2008, the new backup tool will not back up Exchange, so you must go third-party in that case.

    - Rancy

    Author Comment

    I am using Server 2008 and Exchange 2010. I take this statement from Rancy's link to mean I am going to have to buy a third-party tool or use Windows Backup to make a full backup of the entire system volume (that also contains Exchange database):

         "If you are using Server 2008, the new backup tool will not back up Exchange, so you must go third-party in that case."
    LVL 20

    Assisted Solution

    by:Svet Paperov
    Witch 2008 do you have? If it is 2008 R2, it's Windows Backup tool does application aware backup of Exchange with truncating the transaction logs.

    If not, you could try BackupAssist and its Exchnage plug-in There is a 30-day trial version that ou can download.

    Author Comment

    It is 2008 R2. I start the Windows Backup Wizard and do not find a way to specify Microsoft Exchange. I could drill down to the mailbox database folder, but that doesn't seem right when the application-aware wizard in 2003 lets one choose the Exchange Server from the tree view near the top level of the what are the steps to make the backup application-aware?
    LVL 20

    Assisted Solution

    by:Svet Paperov
    You will still have to perform a full backup of the volume(s) where the mailbox databases and the transaction logs reside with VSS Full Backup option enabled (to trucate the transaction logs) but when it comes to restore you will be able to select Appliication restore and to recover the database files on another location. Unfortunately, in your case it means backing up the entire C volume. For Windows Server Backup, you will have to follow the steps in the article you mentioned.

    Btw, BackupAssist also requires backing up the entire volume(s) but it has better scheduling options.

    A piece of advice: if it is possible, split the C volume and move the database file on dedicated volume and the log files on a third one.
    LVL 33

    Accepted Solution

    Personally, I'd recommend taking backups using a third-party backup utility - the best i've known is Symantec. However, natively this is also possible - as stated umpteen times above.

    Here is a short video for you to check how to take backups using native Windows backup for Exchange and it would show you too, how to verify if Exchange is back'd up or not.

    Any questions?


    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Easy CSR creation in Exchange 2007,2010 and 2013
    Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
    This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
    This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now