Forum Discussion

apomazkin's avatar
apomazkin
Level 5
11 years ago

Backup MS SQL Failover Cluster

I have ms failover cluster with ms sql.

cluster consist of two nodes.

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

  • ...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!

3 Replies

  • 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

  • ...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!