<div>
<div class="content wysiwyg-content">
I have a 2 node cluster that is hosting 3 instances of SQL 2008. &nbsp;I am confused as to how backup should be configured for DR purpose:<br />
<br />
Questions running through my mind:<br />
<br />
Do I need to set a seperate backup job targeted to each named cluster resource?<br />
Do I also need to create a backup job for each cluster node?<br />
If I set up a backup job to target both cluster nodes, it would seem impossible since the disk resource is only on one node node at a time.<br />
&nbsp;<br />
I would also like some documentation (links, etc.) as well.<br />

</div>
</div>


I have a 2 node cluster that is hosting 3 instances of SQL 2008.  I am confused as to how backup should be configured for DR purpose:

Questions running through my mind:

Do I need to set a seperate backup job targeted to each named cluster resource?
Do I also need to create a backup job for each cluster node?
If I set up a backup job to target both cluster nodes, it would seem impossible since the disk resource is only on one node node at a time.
 
I would also like some documentation (links, etc.) as well.


Backup Server 2008 SQL Cluster with Backup Exec 12.5

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

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.