Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 4 down vote favorite

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?

share|improve this question

1 Answer

up vote 3 down vote

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.

share|improve this answer
1  
SSIS Packages needing to be installed on both nodes very much depends on how you've got everything configured. – mrdenny♦ Nov 20 '12 at 18:45
This make sense as you laid things out. Thanks! – Mark Bosley Nov 20 '12 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. – Ali Razeghi Nov 20 '12 at 18:55

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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