Video Screencast Help

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.