none
Remote backup of DPM DB RRS feed

  • Question

  • Is there a way to remotely backup the SQL DB for DPM? It will not let me connect through sql management studio? Or do I need to run the DB backup on dedicated disk?
    Monday, January 3, 2011 4:24 PM

Answers

  • Hi crac!

    Using a secondary DPM server will give you the best protection for a primary DPM servers database. This will also give you other options regarding disaster and recovery.

    There are also other options that you could consider. Using the execuable DpmBackup.exe that is located in the BIN catauloge on your DPM server. Using the -DB switch will dump the database DPMDB to the C:\Program Files\Microsoft DPM\DPM\Volumes\ShadowCopy\Database Backups catauloge. There are also some new switches in DPM2010 for the DpmBackup.exe (-location) that you could find intressting.

    Look at this blogpost regarding the use of DpmBackup.exe http://robertanddpm.blogspot.com/2010/09/disaster-recovery-of-dpm-server-made.html

     

    BR

    Robert Hedblom



    Check out my DPM blog @ http://robertanddpm.blogspot.com

    • Marked as answer by crac Monday, January 3, 2011 9:43 PM
    Monday, January 3, 2011 9:16 PM
    Moderator

All replies

  • Hi crac!

    Using a secondary DPM server will give you the best protection for a primary DPM servers database. This will also give you other options regarding disaster and recovery.

    There are also other options that you could consider. Using the execuable DpmBackup.exe that is located in the BIN catauloge on your DPM server. Using the -DB switch will dump the database DPMDB to the C:\Program Files\Microsoft DPM\DPM\Volumes\ShadowCopy\Database Backups catauloge. There are also some new switches in DPM2010 for the DpmBackup.exe (-location) that you could find intressting.

    Look at this blogpost regarding the use of DpmBackup.exe http://robertanddpm.blogspot.com/2010/09/disaster-recovery-of-dpm-server-made.html

     

    BR

    Robert Hedblom



    Check out my DPM blog @ http://robertanddpm.blogspot.com

    • Marked as answer by crac Monday, January 3, 2011 9:43 PM
    Monday, January 3, 2011 9:16 PM
    Moderator
  • DpmBackup.exe -db -targetlocation "G:\DPM DB"

    Looks like it will do what I want. THanks

    Monday, January 3, 2011 9:43 PM
  • Great!

    Your most welcome =)



    Check out my DPM blog @ http://robertanddpm.blogspot.com

    Monday, January 3, 2011 9:54 PM
    Moderator