Well, I helped my boss's boss install 2 nodes of SQL Server 2008 on a Windows server 2008 failover cluster. I did this remotely and I don't have accesse to it. (I run a active-active cluster on Server 2003).

I am waiting for the call on how to Restore a database from a stand-alone database to the new cluster (this is ACTIVE-PASSIVE).

I know the two nodes share the same disk resource, but do I need to RESTORE it to the Active and then to the Passive ?

Or since they share the master database, do I just need one restore?

1 Answer 1


Welcome to StackExchange.

The SQL database will only need to be installed on 1 node, as the nodes share the storage already since SQL Server is 'cluster aware'. However if you use something that is not 'cluster aware' such as SSIS, then packages will have to be installed on both nodes.

The reason you need to do 2 installations is because the nodes do not share installation files found on the local disk of the machine, but anything you do on shared storage and within SQL Server will be retained when failing over. It's 1 database engine and 2 nodes.

Off topic, but a thought might be to have scripts that copy backup files and such so I make my 'backups' drive a cluster resource, and point all of my scripts to the virtual cluster address so even in case of a failover, they work.

  • 1
    SSIS Packages needing to be installed on both nodes very much depends on how you've got everything configured.
    – mrdenny
    Nov 20, 2012 at 18:45
  • This make sense as you laid things out. Thanks! Nov 20, 2012 at 18:52
  • Mr. Denny is correct, he actually made a good blog post on how to cluster SSIS via editing XML files which I had the pleasure to read. MS says it's not supported, but if you use Mr. Denny's method it'll work just fine. Nov 20, 2012 at 18:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.