none
dpmbackup syntax RRS feed

  • Question

  • From the dpmbackup syntax, it seems it can be used to backup a remote SQL instance.  I have a "DPM" server and a "SQL_DPM" server.  I can't seem to get the syntax right to run dpmbackup on DPM to properly backup my DB on SQL_DPM.

    Should it be something simple like:

    dpbackup -db -instancename SQL_DPM

    But that fails saying something like:

    "Error: Failed to connect to server DPM."

    I've tried different combinations of -instancename without any luck...

    Saturday, March 12, 2011 2:52 PM

Answers

  • Hi Marco,

    If you have your DPM DB on a remote SQL, how about backing up the DB using SQL server ,

    or

    On the computer where the DPM database is installed,
    open an elevated command prompt window, type cd <system drive>:\Program Files\Microsoft Data Protection Manager\DPM2010\SQLPrep,

     and then type DPMBackup.exe -db and press ENTER.

    Navigate to <system drive>:\DPMBackup\dpmserver. The file name of the DPM database backup is DPMDB.bak.

    Thanks
    Islam

    • Marked as answer by Marco Shaw Saturday, March 12, 2011 11:21 PM
    Saturday, March 12, 2011 3:14 PM
  • Hi,

    When you ran SQLPREP on the remote SQL server prior to installing DPM, it installed the dpm tools on that remote sql server.

    Using DPMSync [DPMv3OperationsGuide
    http://technet.microsoft.com/en-us/library/ff634215.aspx


    SQLPREP.EXE places dpmbackup and dpmsync in the C:\program files\Microsoft data protection manager\dpm2010\SQLPrep folder.

    TO BACKUP ON REMOTE SQL TYPE:


    CD c:\Program files\Microsoft data protection manager\dpm2010\SQLPrep
    C:\program files\Microsoft data protection manager\dpm2010\SQLPrep>dpmbackup -db -instancename <Instance_name>

    This will place the dpmdb.bak in a c:\dpmbackup\<sql_instance_name_dir> folder.

     

    To restore DPMDB.BAK on remote SQL type:

    C:\program files\Microsoft data protection manager\dpm2010\SQLPrep>dpmsync -restoredb -dbloc c:\dpmbackup\<sql_instance_name_dir>\dpmdb.bak -instancename <sql_server_name>\<Instance_name>

    On DPM server, run dpmsync -sync


    NOTE:  DPMSYNC -sync -reallocatereplica and -datacopied options are only available on DPMServer.

     


    Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.
    Saturday, March 12, 2011 3:19 PM
    Moderator

All replies

  • Hi Marco,

    If you have your DPM DB on a remote SQL, how about backing up the DB using SQL server ,

    or

    On the computer where the DPM database is installed,
    open an elevated command prompt window, type cd <system drive>:\Program Files\Microsoft Data Protection Manager\DPM2010\SQLPrep,

     and then type DPMBackup.exe -db and press ENTER.

    Navigate to <system drive>:\DPMBackup\dpmserver. The file name of the DPM database backup is DPMDB.bak.

    Thanks
    Islam

    • Marked as answer by Marco Shaw Saturday, March 12, 2011 11:21 PM
    Saturday, March 12, 2011 3:14 PM
  • Hi,

    When you ran SQLPREP on the remote SQL server prior to installing DPM, it installed the dpm tools on that remote sql server.

    Using DPMSync [DPMv3OperationsGuide
    http://technet.microsoft.com/en-us/library/ff634215.aspx


    SQLPREP.EXE places dpmbackup and dpmsync in the C:\program files\Microsoft data protection manager\dpm2010\SQLPrep folder.

    TO BACKUP ON REMOTE SQL TYPE:


    CD c:\Program files\Microsoft data protection manager\dpm2010\SQLPrep
    C:\program files\Microsoft data protection manager\dpm2010\SQLPrep>dpmbackup -db -instancename <Instance_name>

    This will place the dpmdb.bak in a c:\dpmbackup\<sql_instance_name_dir> folder.

     

    To restore DPMDB.BAK on remote SQL type:

    C:\program files\Microsoft data protection manager\dpm2010\SQLPrep>dpmsync -restoredb -dbloc c:\dpmbackup\<sql_instance_name_dir>\dpmdb.bak -instancename <sql_server_name>\<Instance_name>

    On DPM server, run dpmsync -sync


    NOTE:  DPMSYNC -sync -reallocatereplica and -datacopied options are only available on DPMServer.

     


    Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.
    Saturday, March 12, 2011 3:19 PM
    Moderator