Solved

DPM 2007 - should mdf and ldf files be excluded

Posted on 2008-10-22
2
1,078 Views
Last Modified: 2012-05-05
I'm running DPM 2007 to backup our servers and applications.  I back up our application data including Exchange, Sharepoint, Virtual Server and SQL Server to tape and all server volumes and system state disk to disk.  My question is:  Should I exclude the SQL data files (.mdf and .ldf) from the server volume back ups?  Since the SQL Servers are being backed up as application data, it seems redundant to backup the data files as well.  

I could not find an answer to this in the MS documentation.
0
Comment
Question by:global-works
2 Comments
 
LVL 7

Accepted Solution

by:
icky2000 earned 125 total points
ID: 22782999
Yes, you should exclude the mdf and ldf files. You should also exclude the Exchange databases and transaction logs. There's no advantage to backing those things up manually as individual files as long as you're doing application-aware backups with DPM. It isn't just redundant backing that stuff up - it's mostly worthless. You won't have much luck restoring from a file-based backup of transactional databases like SQL and Exchange.
0
 

Author Closing Comment

by:global-works
ID: 31508980
Thank you for confirming what I suspected.  We are transitioning from Backup Exec, which won't even allow you to backup those files (and in my opinion is a better product - albiet more expensive).  DPM documentation doesn't seem to mention this anywhere.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever notice how you can't use a new drive in Windows without having Windows assigning a Disk Signature?  Ever have a signature collision problem (especially with Virtual Machines?)  This article is intended to help you understand what's going on and…
A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

825 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