all groups > sql server clustering > march 2005 > threads for march 22 - 28, 2005
Filter by week: 1 2 3 4 5
Defunct Drives Issue
Posted by Joel at 3/28/2005 6:03:16 PM
We've been struggling with a problem for a while now. If anyone has has a
similiar issue, I'd appreciate it if you could share it here as it may lead
me to a solution... The Cluster houses SQL and IIS (bad I know, but it
shouldn't cause the problems we see)
We have the following Cluster h... more >>
SQL Stand Alone to a Cluster
Posted by Bryan at 3/28/2005 12:59:03 PM
All,
I am in the process of upgrading windows 2003 ent with SQL2000 ENT stand
alone server to a clustered environment. The servers that I am using are
identical,
and will be using shared storage via EMC Clariion. I have setup clusters
for fresh/new installs, but I have never upgraded/rein... more >>
taking offline a resource
Posted by liorhal NO[at]SPAM gmail.com at 3/27/2005 4:29:04 AM
what's the meaning of taking the sql-server resource offline ? what is
happning behind the scenes ? is it the virtual server offline ? is it
the specific node service offline ?
why is it that when i move the group (with these services offline)the
cluster admin doesnt restart them ? why bringin... more >>
What would happen to the jobs which are running,while failover occ
Posted by Siva Prasad [SIVA] at 3/26/2005 10:49:02 AM
My question is :
What would happen to the jobs which are running,while failover occurs?
I have a Active \ Passive SQL Server 2000 EE SP3a with Hotfix MS03-031 on
Windows 2003 Enterprise Edition.
When I testesd the Fail over from the Primary node (Node1) to Secondary Node
(Node2) there was... more >>
Error 0x8007042b
Posted by Rubens Luque Sanches Junior at 3/24/2005 10:03:17 PM
Hi,
I have a Windows Server 2003 Cluster with two nodes. I needed restart the
second node for maintenance, after that the Cluster Service on second node
stop ... The first node it's ok.
I tried "Evict Node" and join again, but when the setup try to start cluster
service I receive the follo... more >>
SQL Server Cluster Question
Posted by Yong Zou (SearchIgnite) at 3/24/2005 9:55:31 AM
We have SQL Server cluster setted and running, yesterday, we moved servers
to another location, and assigned cluster servers to new IP address, now our
SQL Server can't start. Does anyone have any suggestion what I should look
to fix that issue
Thanks
Yong
... more >>
Named Instance in a SQL 2000 Cluster
Posted by Rubens Sanches at 3/23/2005 10:07:45 AM
Hi,
When I installed a SQL 2000 Cluster Active/Active I defined one default
instance as SERVER01 and the other instance as SERVER02/I2. Is it
possible to use the second instance without put "/I2" at the end of name
server?
Do I must to install two named instances instead one default inst... more >>
Left Join Problem
Posted by Daniel at 3/22/2005 7:08:23 PM
We would like to restrict the number of records returned
in a LEFT JOIN query but we find that it doesn't work as
it supposed to be.
Query:
select t1.statdescr
from table1 as t1 with (nolock)
left join table2 as t2
on t1.tpklrpap = t2.tfklrpap
and t1.statdescr not like 'CANCEL%'
How... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Change
Posted by Scott at 3/22/2005 10:35:04 AM
Currently have a 2 node windows 2000 cluster, active/passive, with sql 2000
running a data vault that's controlled by node a. Would like to upgrade to
windows 2003, but run active/active with sql running on node b. To do this,
do I have to reinstall sql server? I'm at a loss and all help an... more >>
|