DPM 2010 Backing Up SQL Server

Posted on 2011-10-07
Last Modified: 2012-10-18
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
Question by:Antikythera
    LVL 39

    Accepted Solution

    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

    Author Comment

    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.


    Author Comment

    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

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Create your own, high-performance VM backup appliance by installing NAKIVO Backup & Replication directly onto a Synology NAS!
    Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
    This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
    This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now