Solved

How to break SQL off of the cluster

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

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…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

726 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