Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Backup SQL in cluster

Created: 19 Dec 2012 • Updated: 02 Apr 2013 | 4 comments
This issue has been solved. See solution.

Hello everyone,

I would like to set a backup job on my dbs (SQL 2005) . The structure is form like this: 2 servers in cluster and 1 storage where all dbs and logs reside.Can anyone point me to the right direction?

Do both servers in the cluster need the agent installed?
Do I need to set up a backup job for the dbs on both servers?

Thanks in advance for your replies!

Comments 4 CommentsJump to latest comment

Kiran Bandi's picture

You would need to install agents on both the nodes and configure DB backups from Virtual Server. 

Goodtwin's picture

To take kakagol's question a tad bit further.  Say I have a 3 node SQL cluster:Active Active Passive.

Will this still require a license for all 3 nodes to be able to backup my clustered resources?

When I choose add server from my backup exec 2012 I can see my cluster resource as a server, is this where I would place a Virtual Server?

Kiran Bandi's picture

Will this still require a license for all 3 nodes to be able to backup my clustered resources?

Correct, but checking with licensing team will be a good idea.

When I choose add server from my backup exec 2012 I can see my cluster resource as a server, is this where I would place a Virtual Server?

Yes.

SOLUTION
VJware's picture

Infact, this applies to any clustered resource & not just SQL...So if you have a clustered Exchange or DAG, clustered Hyper-V etc, the requirements are the same...Remote agents installed on every node, licensed for every node & backup via the virtual node.