 |
|
|
|
Next: sql mager
|
| Author |
Message |
External
Since: Dec 19, 2007
Posts: 3
|
(Msg. 1) Posted: Thu Jan 17, 2008 4:27 pm
Post subject: SQL 2005 Cluster Repair
Archived from groups: microsoft>public>sqlserver>clustering (more info?)
|
|
|
I have a 2 node Windows 2003 SQL 2005 Cluster, node 2 was failing so I
evicted it and attempted to rejoin it, when I evicted it the cluster failed,
I had to redo the cluster to get it back up, then added the second node, but
the SQL server, and tools are missing from the cluster. How do I get them
back, I try to reinstall SQL but it sees the existing DB and there is no
option for repair.
Thanks in advance,
Bob Smith |
|
| Back to top |
|
 | |
External
Since: Dec 19, 2007
Posts: 3
|
(Msg. 2) Posted: Thu Jan 17, 2008 9:51 pm
Post subject: Re: SQL 2005 Cluster Repair [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
This is resolved: I had to uninstall SQL then reinstall like I was creating
a new cluster, everything is now working.
"Bob Smith" wrote in message
>I have a 2 node Windows 2003 SQL 2005 Cluster, node 2 was failing so I
>evicted it and attempted to rejoin it, when I evicted it the cluster
>failed, I had to redo the cluster to get it back up, then added the second
>node, but the SQL server, and tools are missing from the cluster. How do I
>get them back, I try to reinstall SQL but it sees the existing DB and there
>is no option for repair.
>
> Thanks in advance,
> Bob Smith |
|
| Back to top |
|
| |
External
Since: Feb 23, 2005
Posts: 443
|
(Msg. 3) Posted: Fri Jan 18, 2008 10:01 am
Post subject: Re: SQL 2005 Cluster Repair [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
FYI, the tools install is not cluster aware. Tools have to be installed on
each node separately.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Bob Smith" wrote in message
> This is resolved: I had to uninstall SQL then reinstall like I was
> creating a new cluster, everything is now working.
>
> "Bob Smith" wrote in message
>
>>I have a 2 node Windows 2003 SQL 2005 Cluster, node 2 was failing so I
>>evicted it and attempted to rejoin it, when I evicted it the cluster
>>failed, I had to redo the cluster to get it back up, then added the second
>>node, but the SQL server, and tools are missing from the cluster. How do I
>>get them back, I try to reinstall SQL but it sees the existing DB and
>>there is no option for repair.
>>
>> Thanks in advance,
>> Bob Smith
> >> Stay informed about: SQL 2005 Cluster Repair |
|
| Back to top |
|
| |
| Related Topics: | SQL 2005 Ent. Cluster - Hi, Can we use Majority Node Set to run SQL Clustering. If yes, Can anyone provide me the step by step guide to do this. Thanks Neeraj Mehra
How to add sp to SQL 2005 cluster? - Hey everyone, We are running Windows 2003 and SQL 2005 in a cluster. We now need to install a service pack for SQL 2005. Anyone know of a step-by-step white paper on how to do it in a cluster? TIA, Clayton
About question of Sql server 2005 cluster. - I am Sql server administrator in a company and I don't have experience of sql server 2005 failedover cluster. Recently my company decides to use cluster to conduct disaster recovery strategy. I want to make a preperation about it, could somebody..
How to move SQL Server 2005 instance from non-clustered to.. - I have two node cluster (active-pasive) and two instances of SQL server 2005 running on that cluster. Default SQL instance was installed as clustered, the second named instance was not installed as clustered. I want to move named instance form..
Multiple IP's (from 2 different networks) on a single SQL .. - Hello there, I'm currently building up a SQL 2005 Active/Standby cluster in a DMZ. I have three NIC's in each server. Each NIC is connected to a different network: 192.168.100.1 is the public NIC 10.0.0.1 is the NIC used for communication betwen the... |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
