DPM vs SSMS maintenance plans

  • We are in the process of completely moving our SQL Server 2008 R2 active/active cluster (6 instances/150+ databases) to multiple SQL Server 2014 clusters utilizing "Always On" Availability groups. I am new to Availability groups, but our exchange group said they have been using this technology for some time now.

    We met today to discuss also moving to Data Protection Manager as opposed to using the SQL Server 2014 Management Studio backup process (we currently use SQL Server 2008 R2 maintenance plans). I was hoping others on this forum could let me know if they currently use DPM and if there are pros and cons.

    Thank you to all they read this and reply in advance,

    Charlie

  • Job saving tip:

    Never ever allow 3rd party (even if it's Microsoft System Center 2012) handle backups.

    But 🙂 it depends on your situation.

    Alex S

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply