?
Solved

Issue with Sql Server failover

Posted on 2013-06-25
4
Medium Priority
?
209 Views
Last Modified: 2013-06-27
Hello,

I have issue with a cluster SQL server removed from fail-over  by mistake

sql
Please advice
0
Comment
Question by:Bahloul
[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
4 Comments
 
LVL 30

Expert Comment

by:Rich Weissler
ID: 39276792
Perhaps it would be good to start with how SQL was removed from the cluster?  Was there a mistake with a command-line command?  Or was SQL removed from the cluster from the SQL installer?
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 39276801
Also was it at the SQL Server level? Or the OS level (i.e. the drives don't failover anymore)?
0
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 1500 total points
ID: 39277207
If you accidentally removed SQL Server, you can just re-add a SQL Server resource to that application by right clicking on the application group "BQDB01dtc" in the left window, selecting "Add Resource" and then "SQL Server". You'll have to configure the last page by adding the SQL Server network and instance names, but it should be pretty straight-forward. You'll have to do the same for the SQL Agent as well.

If you're talking about something more complicated, can you please provide additional detail?
0
 
LVL 3

Author Comment

by:Bahloul
ID: 39281577
Thanks   ryanmccauley :) .
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

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