How to move sql server clustered instance to a separate stand alone server

Tags:
SQL 2008
SQL Server
SQL Server 2008
SQL Server clustering
We are in the process of moving our Production instance and databases.

Would be of nice help if anyone could shed their thoughts on

How to move sql server clustered instance to a seperate stand alone server (along with system and user databases).

We are stopping the cluster, moving the drives to a seperate server and trying to bring the databases back. I think it will not work as easily.

 



Software/Hardware used:
MS SQLSERVER 2008 82, WINDOWS 2008

Answer Wiki

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

Moving the old driver from the old cluster to a new standalone server will work just fine, provided that the SQL Server instance version is identical.

The easiest way to do this is to present a new temporary LUN to the new server with the same drive letter as the drive which hosts the master database on the cluster. Install the instance on the new server configuring the master database to be in the exact same location as it is on the cluster.

When you are read to migrate, on the production server stop both SQL Server instances. Remove the LUN from the new server. Attach all the LUNs from the cluster to the new machine. Start the SQL Instance on the new machine.

If you are moving from a Windows 2003 cluster, and the disks were first setup on a Windows 2003 clustered machine you should create new LUNs and robocopy the files to the new LUNs. Windows 2003 when clustered wrote a clustered disk information which isn’t always compatible with non-clustered servers.

If you are going from Windows 2008 clustered to Windows 2008 non-clustered you’ll be fine.

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