?
Solved

How to break SQL off of the cluster

Posted on 2008-10-17
1
Medium Priority
?
1,213 Views
Last Modified: 2012-05-05
We have SQL 2000 installed on Windows 2003 cluster enviroment.

2 dell servers with shared array storage.

1 server died and we want to break SQL off of the cluster, and run locally.

any articles or suggestions how to do it?
0
Comment
Question by:itmti
1 Comment
 
LVL 22

Accepted Solution

by:
Paka earned 2000 total points
ID: 22747735
http://msdn.microsoft.com/en-us/library/ms187858.aspx

Since it isn't hurting anything using a one node cluster, why not keep it on the cluster?  If you need to "de-cluster" your SQL server, you'll need to create another SQL instance, then use the article above to ALTER DATABASE.  Depending on your schema and number of databases, this could be a big task.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Batuhan Cetin In this article I will be guiding through the process of removing a failed DC metadata from Active Directory (hereafter, AD) using the ntdsutil tool in a Windows Server 2003 environment. These steps are not necessary in a Win…
Numerous times I have been asked this questions that what is it that makes my machine log on so slow, there have been cases where computers took 23 minute exactly after taking password and getting to the desktop. Interesting thing was the fact th…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question