SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Microsoft Data Protection Manager (DPM), thoughts and best practices ?


Microsoft Data Protection Manager (DPM), thoughts and best practices ?

Author
Message
clive-1122102
clive-1122102
SSC-Enthusiastic
SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)

Group: General Forum Members
Points: 106 Visits: 14
At my current employer (which I joined in November 2015) they use Microsoft Data Protection Manager (DPM) 2012 SP1 for all their backups and with SQL Server backups there's just something about it I don't like, in general there's a feeling in my bones that I don't like DPM but maybe this is due to a lack of skills / familiarity with it and actually it's a very good backup product ?.

I thought I'd start this thread so that I can ask a few questions about DPM specific to SQL Server backups and maybe get some advice ?.

Our ERP system is using SQL Server 2005, protected by DPM, and I feel twitchy about the DB's recovery model being simple, it just seems alien to me, however with DPM is it preferred to use simple recovery and regular point in time backups or should I still be using full recovery model and regularly backing up logs like I usually would do instead ?.

Thanks.
clive-1122102
clive-1122102
SSC-Enthusiastic
SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)

Group: General Forum Members
Points: 106 Visits: 14
Only 2 days have gone by since my post, which is not much, but with no replies so far I'm starting to think that those of us who like to sleep safely at night don't use DPM to natively backup our SQL Server db's ? ;-)

(Other than using DPM to backup the backups we create within SSMS itself ?)
Super Cat
Super Cat
SSCertifiable
SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)

Group: General Forum Members
Points: 5776 Visits: 3042
This tool doesn't work very well with T-LOGS and point in time recovery. It did however do some sort of recovery, but not to the specific time I requested. It has a lot of drawbacks too.

One which I remember is if you decommission it you lose all historic backups. It failed most of the test I arranged for it.

It is pretty poor. Only backup with SQL specific backup tools. ie redgate,idera, SQL native backups or T-sql OLA HALENGREN scripts.

There is enough about it online to review the drawbacks.

Avoid it at all costs. But hey test it yourself.
Super Cat
Super Cat
SSCertifiable
SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)

Group: General Forum Members
Points: 5776 Visits: 3042
In terms of recovery, it depends on how much data they are willing to lose in the event of a disaster or if physical corruption is found. If it is an highly transactional db then Simple mode may not be best and DPM will certainly not be the best backup tool\method.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search