Solved

How to break SQL off of the cluster

Posted on 2008-10-17
1
1,166 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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I've always wanted to allow a user to have a printer no matter where they login. The steps below will show you how to achieve just that. In this Article I'll show how to deploy printers automatically with group policy and then using security fil…
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…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

772 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now