none
DPMBACKUP - Fails: please install SQL 2012 SP1 Tools RRS feed

  • Question

  • I have a standalone DPM 2012R2 server with SQL 2008R2 installed (SQL Server 10.50.4033)

    I would like to backup the DPM database using the DPMBACKUP tool and schedule this in case I lose my DPM server.

    When I try and run dpmbackup.exe I get, "Backup Failed. Please install SQL 2012 Service Pack 1 Tools from installation media."

    Since, I am running SQL Server 2008R2, I don't think that I should install SQL 2008 Service Pack 1 Tools.  Should I not install from SQL 2008R2?

    Thanks... Chris


    • Edited by rosenstc Monday, July 6, 2015 7:17 PM typo
    Monday, July 6, 2015 7:16 PM

Answers

  • Hi

    Yes, execute the SQLManagementStudio_x64_ENU.exe under the SQLSVR2012SP1 folder on the installation media.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    • Marked as answer by rosenstc Monday, July 6, 2015 11:18 PM
    Monday, July 6, 2015 10:46 PM
    Moderator

All replies

  • Hi,

    Yes, you need to install the tools as instructed if you want to use dpmbackup.exe make your DPMDB backups.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Monday, July 6, 2015 10:41 PM
    Moderator
  • Just to confirm, I should install  SQL 2012 Service Pack 1 Tools even though I am running SQL Server 2008R2?

    Monday, July 6, 2015 10:43 PM
  • Hi

    Yes, execute the SQLManagementStudio_x64_ENU.exe under the SQLSVR2012SP1 folder on the installation media.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    • Marked as answer by rosenstc Monday, July 6, 2015 11:18 PM
    Monday, July 6, 2015 10:46 PM
    Moderator
  • Thank you... I will install the basic SQL 2012 SP1 tools Feature and try the DPMBACKUP again.  If it still fails, I might as well just upgrade from SQL 2008 to 2012.  This should be straight forward I think.


    • Edited by rosenstc Monday, July 6, 2015 11:47 PM
    Monday, July 6, 2015 11:18 PM
  • I'm curious -- having the same problem.  Did this fix the problem with dpmbackup?
    Wednesday, September 23, 2015 6:37 PM
  •  I recall that after installing the SQL 2012 SP1 tools, dpmbackup.exe did not work.  So, I did end up upgrading from SQL 2008 to 2012. After that, I had no issues using dpmbackup.exe.   

    Wednesday, September 23, 2015 6:50 PM