Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 226
  • Last Modified:

Issue with Sql Server failover

Hello,

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

sql
Please advice
0
Bahloul
Asked:
Bahloul
1 Solution
 
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
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
 
Jim P.Commented:
Also was it at the SQL Server level? Or the OS level (i.e. the drives don't failover anymore)?
0
 
Ryan McCauleyDatabase and Reporting ManagerCommented:
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
 
BahloulAuthor Commented:
Thanks   ryanmccauley :) .
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now