Solved

DPM 2007 - should mdf and ldf files be excluded

Posted on 2008-10-22
2
1,066 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
Comment Utility
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
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

VM backups can be lost due to a number of reasons: accidental backup deletion, backup file corruption, disk failure, lost or stolen hardware, malicious attack, or due to some other undesired and unpredicted event. Thus, having more than one copy of …
Are you looking to recover an email message or a contact you just deleted mistakenly? Or you are searching for a contact that you erased from your MS Outlook ‘Contacts’ folder and now realized that it was important.
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

772 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

10 Experts available now in Live!

Get 1:1 Help Now