Having problems service packing (sp2) on 4 node cluster

underprocessablep.s. I should have added that this is all x64 windows and sql.
"Mark Broadbent" <nospam@.nospam.com> wrote in message
news:%232X3csx3HHA.4476@.TK2MSFTNGP06.phx.gbl...
> Hope somebody has had this problem too..
> Keep trying to install SP2 (on active node as per instructions) and have
> had several problems.
> When I had all four instances failed onto the node and I was trying to SP
> all of them the installer would simply disappear (and close) - no process
> remained.
> Then I attempted to do the install only to first instance (failing other 3
> over to other nodes). Installer was slightly more successful, upgrading
> all shared components but failed on the instance based ones e.g. the SQL
> Service and Analysis service.
> After reboots and several attempts to upgrade these two components of the
> first instance (which causes the installer to disappear). I have decided
> to upgrade the instance components of another instance via another
> physical host. Now the installer seems to just be hanging doing nothing
> (around 2 hours now). See screen shot. Any one got any advice?
> Thanks in advance,
> Mark.
>
>

Has anyone resolved [sqsrvres] StartResourceService: StartService?

Hello all,
I am working with a 2 node SQL Server 2000 cluster on Windows Server 2003.
Each node is a primary node for one of two SQL instances (Active/Active).
Everything worked fine until I applied the latest SQL Server service pack
(MS03-031). When I try to move a group (disks and SQL resources) from a
primary node to the secondary node the disks transfer fine but the SQL Server
service fails to start and the group goes back to its original owner after 3
tries. The following errors are in the event log. Any ideas? -Phil
[sqsrvres] StartResourceService: StartService (MSSQL$Inst1) failed. Error:
41d
[sqsrvres] OnlineThread: ResUtilsStartResourceService failed (status 41d)
[sqsrvres] OnlineThread: Error 41d bringing resource online.
Error 41d corresponds to message:
The service did not respond to the start or control request in a timely
fashion.
So the problem seems the sql service itself is unable to start on the other
node. To troubleshoot further you will need to
1- check app + sys logs for any other clues, what errors do you see when
attempting to start the MSSQL$Inst1
do you see that the MSSQL$Inst1 started but then shut down? Are there any
errors stating some dll could not be loaded? Or do you only see the errors
you reported?
2. check the sql error logs(c:\program files\microsoft sql
server\mssql$INST1\LOG\errorlog), if SQL Server started a new errorlog file
should have created during this time. Was one created, if so check for any
errors
3. Check for: "The application failed to initialize properly" error when
starting SQL - ID: 326571.KB.EN-US
4. can you start sql on from a command prompt on the second node? To do
this you will need to fail over to node2, bring online the network name and
sql disks, now run (sql resource would still be offline/failed state)
c:\program files\microsoft sql server\mssql$INST\binn\sqlservr -iINST -c
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
sql

Has anyone resolved [sqsrvres] StartResourceService: StartService?

Hello all,
I am working with a 2 node SQL Server 2000 cluster on Windows Server 2003.
Each node is a primary node for one of two SQL instances (Active/Active).
Everything worked fine until I applied the latest SQL Server service pack
(MS03-031). When I try to move a group (disks and SQL resources) from a
primary node to the secondary node the disks transfer fine but the SQL Server
service fails to start and the group goes back to its original owner after 3
tries. The following errors are in the event log. Any ideas? -Phil
[sqsrvres] StartResourceService: StartService (MSSQL$Inst1) failed. Error:
41d
[sqsrvres] OnlineThread: ResUtilsStartResourceService failed (status 41d)
[sqsrvres] OnlineThread: Error 41d bringing resource online.Error 41d corresponds to message:
The service did not respond to the start or control request in a timely
fashion.
So the problem seems the sql service itself is unable to start on the other
node. To troubleshoot further you will need to
1- check app + sys logs for any other clues, what errors do you see when
attempting to start the MSSQL$Inst1
do you see that the MSSQL$Inst1 started but then shut down? Are there any
errors stating some dll could not be loaded? Or do you only see the errors
you reported?
2. check the sql error logs(c:\program files\microsoft sql
server\mssql$INST1\LOG\errorlog), if SQL Server started a new errorlog file
should have created during this time. Was one created, if so check for any
errors
3. Check for: "The application failed to initialize properly" error when
starting SQL - ID: 326571.KB.EN-US
4. can you start sql on from a command prompt on the second node? To do
this you will need to fail over to node2, bring online the network name and
sql disks, now run (sql resource would still be offline/failed state)
c:\program files\microsoft sql server\mssql$INST\binn\sqlservr -iINST -c
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

hardware upgrade of active/active cluster

I'm planning a hardware upgrade of our active/active dual node Windows
2000 sql cluster. Hostnames and IP addresses will remain unchanged.
Here's a high level overview of my plan..
1. move all cluster groups/resources to node 2
2. shutdown sql services on node 1
3. uninstall MSCS on node 1
4. evict node 1 from cluster using cluster administrator on node 2
5. power down node 1
6. reset node 1 account in domain
7. add new node 1 to domain
8. install MSCS on new node 1
9. install sql server on new node 1
10. install sql sp2 on new node 1
11. add new node 1 to existing cluster
12. verify that all resources can move to new node 1 correctly
** repeat for node 2
I know this has been discussed several times before in this newsgroup,
but there's a few extra steps in there that I believe have not been
addressed in the past. Does the above look accurate and also is it
feasible to roll back to a ghost image and backup of the quarum in the
event of a problem with either server?
Thanks in advance,
David
Step 1.5 Uninstall SQL from Node 1. If you do not do this step, you cannot
do step 9. Uninstalling SQL also tells the existing cluster not to look for
that node any longer as a valid SQL host node. You can do it as step 8.5,
but you will have to wait on some timeouts since the node is no onger there.
I haven't tried a ghost of the quorum as a restore technique, but I suspect
that given the SQL configuration changes, it wouldn't work.
Since you are reusing node names, make sure you have removed all traces of
the nodes from Active Directory and allowed it to globally synch before
trying to add the machines back in.
IMHO, I would take the opportunity to upgrade to Windows 2003 as a host OS
during the upgrade. In that case, you would need to be on at least SP3a
before starting the cluster upgrade.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
<davidawest@.gmail.com> wrote in message
news:1132725533.573424.291710@.z14g2000cwz.googlegr oups.com...
> I'm planning a hardware upgrade of our active/active dual node Windows
> 2000 sql cluster. Hostnames and IP addresses will remain unchanged.
> Here's a high level overview of my plan..
> 1. move all cluster groups/resources to node 2
> 2. shutdown sql services on node 1
> 3. uninstall MSCS on node 1
> 4. evict node 1 from cluster using cluster administrator on node 2
> 5. power down node 1
> 6. reset node 1 account in domain
> 7. add new node 1 to domain
> 8. install MSCS on new node 1
> 9. install sql server on new node 1
> 10. install sql sp2 on new node 1
> 11. add new node 1 to existing cluster
> 12. verify that all resources can move to new node 1 correctly
> ** repeat for node 2
> I know this has been discussed several times before in this newsgroup,
> but there's a few extra steps in there that I believe have not been
> addressed in the past. Does the above look accurate and also is it
> feasible to roll back to a ghost image and backup of the quarum in the
> event of a problem with either server?
> Thanks in advance,
> David
>

Hardware general question about sql

Dear folks,
Nowadays, we have got an Active-Active cluster for to attend our business as
usual. Each node own the following main features:
-8 processors xeon 700 Mhz
-8 Gb RAM
-RAID 5 (up to 400 gb ) 12 disks approx.
-OS 32 bit (Advanced Server)
-Sql2000k with sp3
-Quorum disk have 36,6 GB
-Our growing per w is almost 50 gb.
-Databases are forty.
The above configuration was bough five years ago, so that, which could be a
good migration of this hardware?
We are thinking over to buy Itanium but we don't know if TCO is good with
such growing of data.
Maybe a good solution will be buy 64-bit hardware and by the moment to
install our sql2000k and within six months or so (when SP1 for sql server
2005 is released) move the data to that version.
Any input will be greatly.
Regards,Enric wrote:
> Dear folks,
> Nowadays, we have got an Active-Active cluster for to attend our
> business as usual. Each node own the following main features:
> -8 processors xeon 700 Mhz
> -8 Gb RAM
> -RAID 5 (up to 400 gb ) 12 disks approx.
> -OS 32 bit (Advanced Server)
> -Sql2000k with sp3
> -Quorum disk have 36,6 GB
> -Our growing per w is almost 50 gb.
> -Databases are forty.
> The above configuration was bough five years ago, so that, which
> could be a good migration of this hardware?
> We are thinking over to buy Itanium but we don't know if TCO is good
> with such growing of data.
> Maybe a good solution will be buy 64-bit hardware and by the moment to
> install our sql2000k and within six months or so (when SP1 for sql
> server 2005 is released) move the data to that version.
> Any input will be greatly.
> Regards,
What hardware issues, if any, are you currently having? Assuming your
queries are performance tuned (which should always be the first order of
business when it comes to performance), you need to determine where the
hardware is failing you. Are you CPU bound? Disk bound? Memory bound?
50GB of growth per w is significant. Could you have meant 50MB /
w? Given that you only have 400GB of disk, 50GB / w doesn't leave
you much time.
You have a powerful, but older server. You could probably get better
performance out of a modern 4-way Xeon server. Since SQL 2005 will run
on 64-bit AMD and x86 boxes, I might consider waiting for that version
and skip Itanium.
If you determine that you are disk bound, you may want to consider using
a SAN or a different RAID implementation. It sounds like you have RAID 5
for everything (data, logs, temdb). You will normally get much better
performance using a RAID 1+0 array for data, and RAID 1+0 or RAID 1
arrays for log files and tempdb. Unless activity is low during log
backups and full backups, you may want to consider backing up to an
array that's different than the data array.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||If you're not experiencing any problems with your current set-up, and the SW
side is fully optimized, then IMHO you don't really have to change anything.
ML

Hangs on Applying Computer Settings

I have 2 nodes Cluster Active/Passive on Windows 2003. When I reboot either
one, it comes fast no problem but when I logon to the node it takes 15
minutes waiting on "Applying Computer Settings" message then it will show
the desktop.
I didn't install SQL 2000 yet, I need to solve this issue before I install
it.
Does any one have this issue that it takes so long to logon?
Thanks
Ayad
Sounds like a service start issue. Check your system event log to see if
any services are hanging on startup. BITS is one I typically have problems
with. Setting it to manual startup seems help.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Ayad" <ashammout1@.hotmail.com> wrote in message
news:eU0BdXBzEHA.352@.TK2MSFTNGP14.phx.gbl...
> I have 2 nodes Cluster Active/Passive on Windows 2003. When I reboot
either
> one, it comes fast no problem but when I logon to the node it takes 15
> minutes waiting on "Applying Computer Settings" message then it will show
> the desktop.
> I didn't install SQL 2000 yet, I need to solve this issue before I install
> it.
> Does any one have this issue that it takes so long to logon?
> Thanks
> Ayad
>

HA clustering with replication

Node A and Node B (sql server 2000) are being replicated to each other
serving data partitioning.
What are the options to set up HA clustering and which one is the most
economic one?
Appreciate any help.
I think you want a cluster. Here are a few guides for you:
General Clustering information
http://www.microsoft.com/ntserver/su...tering_faq.asp
http://www.microsoft.com/downloads/d...displaylang=en
http://www.microsoft.com/windows2000...ustersteps.asp
SQL Clustering
http://www.microsoft.com/technet/pro.../failclus.mspx
http://www.microsoft.com/usa/webcasts/ondemand/1883.asp (Webcast)
Now for the price issue. HA and price never agree. You can either have one
or the other.
My website also has a ton of clustering information on it.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Wen Chang" <WenChang@.discussions.microsoft.com> wrote in message
news:235AAE4A-F675-4700-8795-8E9DD7CA5DC4@.microsoft.com...
> Node A and Node B (sql server 2000) are being replicated to each other
> serving data partitioning.
> What are the options to set up HA clustering and which one is the most
> economic one?
> Appreciate any help.