<div>
Hi Icohan,<br />
<br />
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 &nbsp;listed.<br />
<br />
Cheers
</div>


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.

Cheers

<div>
Got it back up and running after a few hotfix installs, however it still doesnt show the second SQL instance or associated db file<br />
<br />
database. As a workaround for now, I'm running a daily sql backup then using dpm to backup that file.<br />
<br />
:S
</div>


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.

:S

<div>
<div class="content wysiwyg-content">
I have recently installed DPM 2010 and setup all my protection groups no problem. <br />
<br />
On my SQL protection group, it shows &quot;All SQL servers&quot; (\STM-SQL\) and its databases. However, on my SQL server there are is sub-server (\\STM_SQL\LL). <br />
<br />
This does not display as an option to backup in DPM so how am i supposed to add these databases to a protection group?<br />
<br />
Thanks<br />
<br />
Please see attached screenshot from SQL and DPM servers. <a href="https://filedb.experts-exchange.com/incoming/2011/10_w41/510152/SQLDPM.jpg" target="_blank" title="Screenshots (258 KB)"><img alt="Screenshots" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2011/10_w41/800_510152/SQLDPM.jpg" /></a>
</div>
</div>


SQLDPM.jpg

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?

Thanks

Please see attached screenshot from SQL and DPM servers. 

DPM 2010 Backing Up SQL Server

The term "Backup" means the methods and processes involved to copy computer data (system data as well as application data) to media other than the ones where the data originally live (disk, tape, optical, cloud). "Restore" in turn means the methods and processes involved in data recovery, i. e., bringing back copied computer data to their original location. Backup/Restore primarily serves as a means of protection against data loss, be it due to disaster, corruption or sabotage. It can also be used for recovering data from an earlier point in time and even for cloning machines or applications. There is a wide variety of backup/restore software available, from expensive commercial products to free or open source tools.

Storage Software

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.