cancel
Showing results for 
Search instead for 
Did you mean: 

Backup MS SQL Failover Cluster

apomazkin
Level 5

I have ms failover cluster with ms sql.

cluster consist of two nodes.

How can i backup sql instance? i must backup all nodes?

1 ACCEPTED SOLUTION

Accepted Solutions

CraigV
Moderator
Moderator
Partner    VIP    Accredited

...you backup the virtual node that shows up...ie. your SQL server's name itself, not the nodes. Although you can backup the System State and any other information on the physical nodes you need.

Thanks!

View solution in original post

3 REPLIES 3

Siddhant_Saini
Level 6
Accredited Certified

Hello,

You'll need to install the Backup Exec Remote Agent for Windows Servers(RAWS) on both the nodes. Backup Exec would then list the SQL resource. 

Note: You may need to perform a reboot of each node after installation of RAWS. As such, please install it on Node1 first, move the resources, reboot and then do the same on Node 2. 

Installation of RAWS: http://www.symantec.com/docs/TECH36546

CraigV
Moderator
Moderator
Partner    VIP    Accredited

...you backup the virtual node that shows up...ie. your SQL server's name itself, not the nodes. Although you can backup the System State and any other information on the physical nodes you need.

Thanks!

apomazkin
Level 5

Name of SQL instance.
thanks!