none
DPM 2012 DB Backup Using SQL Maintenance Plan RRS feed

  • Question

  • We use DPM 2012 to backup our production environment over a WAN VPN tunnel. Since the DPM 2012 server lives in our data center, we don' t find the need to do long term backups to tape. The only issue with this setup is backing up the actual DPM DB. We wish to use a SQL maintenance plan to do so. However, it has been a real struggle. At first DPM was throwing an error saying a maintenance plan could not be created. After doing some reading, we added Integration Services and could at least begin the process. Just wondering if this is considered to be a good practice and if there is something special about the DPM DB which would prevent a backup made in this manner to be restored.
    • Moved by Larry Yin Wednesday, March 28, 2012 11:09 PM (From:DPM 2012 Beta - Locked)
    Wednesday, November 30, 2011 1:14 AM

All replies

  • Here you can find the answer about the SQL maintenace tasks and DPM

    http://social.technet.microsoft.com/Forums/en-GB/dataprotectionmanager/thread/f6a85656-c7cf-4ddb-99d0-df2277db1a6c

    DPM is able to backup it's own DB - from DPM console, or by 'dpmbackup.exe' command. To restore DPM DB file, you can use 'DPMsync' command.


    Martin
    Tuesday, December 6, 2011 1:22 PM
  • Thanks Martin. We're aware of the built in ability to backup the DPM database. However, it requires that you do so to a tape drive. We wish to backup the database to a single, internal drive or even a removable USB key. It seems foolish and expensive to buy a tape drive solely for DPM DB backup when SQL is perfectly capable of backing itself up to a local drive. Thoughts?
    Tuesday, December 6, 2011 1:41 PM
  • and what about DPMbackup/dpmsync commands, I mentioned?

    e.g. DpmBackup.exe -db -targetlocation "G:\DPM DB"

    They are suitable for things you mentioned. Moreover you can take a look on some Virtual Tape Library solution to help you as well. (e.g. Firestreamer)

     


    Martin
    • Proposed as answer by MartinDZ Tuesday, December 6, 2011 3:21 PM
    Tuesday, December 6, 2011 2:14 PM
  • Martin, I didn't "connect the dots" until you specified the example above. Brilliant. This will work. Looks like we can make this into a script that can be timed to execute. Thanks so much. 
    Tuesday, December 6, 2011 3:19 PM