Solved

How to break SQL off of the cluster

Posted on 2008-10-17
1
1,197 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 500 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

So you have two Windows Servers and you have a directory/folder/files on one that you'd like to mirror to the other?  You don't really want to deal with DFS or a 3rd party solution like Doubletake. You can use Robocopy from the Windows Server 200…
On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

685 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