moving an existing active/passive 2005 SQL cluster onto an existing active/active SQL 2008 cluster.

5 pts.
Tags:
Active/Passive SQL Server 2005 Cluster
Cluster management
SQL Server
SQL Server 2005
Windows Server 2008
I have been tasked with moving an existing active/passive 2005 SQL cluster onto an existing active/active SQL 2008 cluster.

The active/active 2008 SQL cluster consists of two nodes that are running Windows Server 2008 Enterprise edition. These nodes connect to an EMC SAN which has been operating flawlessly for about one year.

The active/passive 2005 SQL Cluster consists of two nodes running Windows Server 2003 Enterprise Edition. It is connected to an IBM EXP400 SAN which has been in production for about three years.

My question is what would be the best way to acheive this? My plan as of right now is to stop SQL Server 2005 to kill all connections and then restart SQL. Then I would detach the database and copy it to an external hard drive. I would then insert the SQL Server 2008 disk into the drive of the 2008 Server and select create a new SQL server fail over cluster. Once that is set up I would then reattach the databases to the new 2008 active/passive cluster.

I am sure I am missing something here as this sounds way to easy so I would love it if someone could verify my steps here. Although I have been working with clusters for a number of years, I have never had to run more than one cluster per server. I just want to make sure I have a full understanding before I go ahead with this.

 

Thanks,

Mike Chubb

ASKED: July 15, 2010  3:33 PM
UPDATED: July 15, 2010  5:51 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

That all sounds about right. Why are you setting up a new instance of SQL Server for this database? Why not just attach the database to the existing SQL Server 2008 instance?

Don’t forget to script out any logins that you will need on the new instance, jobs, SSIS packages, etc.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following