cancel
Showing results for 
Search instead for 
Did you mean: 

how to backup clustered SQL servers .bak files

m_amir
Level 3

Hi every one. we have a clustered SQL server included two nodes. it takes databases backups and put the .bak files on a LUN that is assigned to the Clustered SQL role. so when ever SQL server failes and moves to another node this LUN will move too. So what i need is how to take backup from .bak files with backup exec.

Thanks in advanced

1 REPLY 1

CraigV
Moderator
Moderator
Partner    VIP    Accredited

Hi,

 

At a basic level you'd simply license and install 2 x RAWS agents and install them onto each of the nodes. Then run a configuration of a backup job and select the virtual node name, NOT the individual hosts (unless you want to backup OS files etc. on each). This way, when the cluster fails over, BE is aware of the virtual node containing all the relevant data. If you pointed it to a specific host, if that failed over the backups would fail.

If you want to backup SQL itself you'd need the relevant database agent to enable this.

Thanks!