?
Solved

How to break SQL off of the cluster

Posted on 2008-10-17
1
Medium Priority
?
1,206 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

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

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…
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Suggested Courses

770 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