August 4, 2003 at 10:57 am
Hi All,
Has anybody installed W2K service pack 4 on a sql 2000 server ? are there any issues problems in it ?
Thanks.
August 6, 2003 at 8:28 am
Hey ranec,
I have installed sp4 on only two boxes so far. One was a production machine that I was upgrading, the other a box that was in the process of initial rollout. I have yet (fingers crossed) to have any problems with either.
Dan
August 6, 2003 at 9:36 am
This server, SSC, runs IIS and SQL as well as a few other email software items. We instlaled SP4 about a week after release and it hasn't caused any issues as of yet.
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
August 19, 2003 at 2:58 am
Hi All,
I have personally seen two issues. The one pertains to Clusters specifically, and is basically that SQLServerAgent stops firing Operating System jobs.
I had to re-create the schedules that were affected.
The second also seems to do with SQLServerAgent, but I can't really put my finger on it. One of the server jobs reported that it was "EXECUTING", however, the process that it was supposed to spawn didn't exist. This also resulted in the job not firing when it was supposed to. After killing this job, the issue never occured again. So who knows.
August 19, 2003 at 3:15 am
ifx,
In regard to...
quote:
SQLServerAgent stops firing Operating System jobs.I had to re-create the schedules that were affected.
I'm interested in the problem, even though I haven't applied SP4.
Was it just a matter of re-establishing the schedules to get it going again?
Cheers,
- Mark
Cheers,
- Mark
August 26, 2003 at 2:32 am
Hi Mark,
Yes, re-creating the schedules resolved the problem. I have had no luck finding the exact reason for the problem though.
August 26, 2003 at 6:36 am
Yes. I am having one Win2K SP4 machine. I did not have any problems so far. Let us know if we need to look for any specific issues.
.
August 26, 2003 at 8:48 am
Four more boxes and no issues yet... 🙂
Have not yet patched any of the clusters though.
Thanks for the info ifx!
Dan B
December 23, 2003 at 1:24 pm
actually just got a win2k sp4 server dumped on me ... orders - install sqlserver 2000 sp2 with hotfix.
On the schedule problem, it was first reported in win2k sp3 on the KB. known issue.... the SP blows away the security hashs on the jobs and the schedules "disappear", but they are still there , hidden ! We had some stuff that was never found again,.,....recreate works. You can log as a full admin and see em all, but will have to restore permissions to the logon that owned them for each of them for that user to see em again.
I am looking for any backlash to installing SP2 sql server on SP4 WIN2k.. to move forward on SP I have to bring along our DIGEX host due to replication, and they are not on SP3a yet either....
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply