Solved

DPM 2007 - should mdf and ldf files be excluded

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

Suggested Solutions

Title # Comments Views Activity
Cloud Backup -- search by date range ? 1 38
Acronis True Image is Reporting a Bad Sector! 12 132
Backup Data/Portable NAS storage 4 65
How to format tape Cartridge to LTFS 6 64
When you upgrade from Windows 8 to 8.1 or to Windows 10 or if you are like me you are on the Insider Program you may find yourself with many 450MB recovery partitions.  With a traditional disk that may not be a problem but with relatively smaller SS…
Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
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). …
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

919 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

16 Experts available now in Live!

Get 1:1 Help Now