Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 547
  • Last Modified:

DPM 2010 Backing Up SQL Server

I have recently installed DPM 2010 and setup all my protection groups no problem.

On my SQL protection group, it shows "All SQL servers" (\STM-SQL\) and its databases. However, on my SQL server there are is sub-server (\\STM_SQL\LL).

This does not display as an option to backup in DPM so how am i supposed to add these databases to a protection group?


Please see attached screenshot from SQL and DPM servers. Screenshots
  • 2
1 Solution
lcohanDatabase AnalystCommented:
LIVELINK is just another SQL "instance" running on the same box as STM-SQL "defualt" SQL instance and it should be covered by the "All SQL Servers". What is under the "Auto) LSTM-SQL1 if you expand that group?  I beleive you should see both LSTM-SQL1 and LSTM-SQL1\LIVELINK
AntikytheraAuthor Commented:
Hi Icohan,

I am having some issues with DPM hanging and MMC snap in failing when i try to open the protection groups. When I fix this issue i will reply to your question, i do know though however when i goto the recovery console there is no LSTM-SQL1\LIVELINK  listed.

AntikytheraAuthor Commented:
Got it back up and running after a few hotfix installs, however it still doesnt show the second SQL instance or associated db file

database. As a workaround for now, I'm running a daily sql backup then using dpm to backup that file.


Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now