 |
|
|
|
Next: sql mager
|
| Author |
Message |
External
Since: Jan 15, 2008
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: Jan 15, 2008
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: Jan 10, 2008
Posts: 111
|
(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 Cluster on Windows 2008 Datacenter - I am currently working to get a test cluster online using Windows 2008 Datacenter x64 with SQL2005 Enterprise x64. Although the 2008 cluster is up and reports that it is running fine and shared storage is attached and online, SQL setup does not give me..
Applying a hotfix to a SQL Server 2005 failover Cluster - Hi. Was hoping to get some advice on applying a hotfix to a SQL Server 2005 failover Cluster. The hotfix I am applying (KB933508) relates to a Maintenance Plans issue with Server 2005 Service Pack 2. During installation I'm advised that unless the SQ...
SQL 2005 Cluster install error/Group cannot be validated - Hello, I'm installing 2 node failover SQL 2005 cluster. For some reason I'm getting the following error after I provided domain groups for cluster services: "You don’t have privileges to add accounts to the domain groups specified for this fai...
CLUSTER NAME - Hi , is there any command to display current cluster name through query . Thanks ARR
Using SQL Mail in a cluster - Hello, I'm trying to set up alerts for jobs and backups, using sql mail. Will this work in a clustered enviroment? if so, can you please forward some information on how to get this set up? thanks in advace. Calvin |
|
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
