MSSQL is down

[vonbrocklin]

Any word on MSSQL? It has been down for at least an hour and I have not heard back on my support ticket. Last time this happened it was down for 6 hours, so let's hope we are not in for a repeat:

http://www.matrixwebhosting.net/foru...&threadid=5306

Please provide an update, my clients are going nuts.

[vonbrocklin]

Also, how come mssql.hsphere.cc is not on the ipMon status page?

[admin]

I am updateing mssql right now as the SQL slammer is trying to hit.. Just waiting on the update to finish. I will also get mssql added to status I thought it was on there.

[admin]

Should be good to go and has SP3a on it now..

[bigdave]

Brad has added it...

[dlrmartin]

brad, so later with sp3a. It has 4 months old!

Ms:
SQL Server 2000 Service Pack 3a
Content Updated: May 20, 2003

You should try to mantain up to date all servers!

And reaffirm my assent to upgrade webservers to win2003 !

[Brangwyn]

I understood all of the servers were updated several months ago, what happened ?

Don't rush into Win2003 dlrmartin, it isn't that "stable" yet from my experieince, wait till at least the first SP comes out as a good rule of thumb with any new MS OS.

[admin]

Hmmm, maybe you guys should check MS Date Published:
8/27/2003, we had Microsoft SQL Server 2000 Service Pack 3 installed this should of stoped the worm but now there is Microsoft SQL Server 2000 Service Pack 3a I just found it yesterday. Thats when I went ahead and updated it to 3a and its less then a month old not 4 months.

http://www.microsoft.com/downloads/d...displaylang=en

[Brangwyn]

You don't need 3a if you already have 3 Brad. Hence me wondering why you were applying this becuase I thought you already had SP3 on there.

If you have applied SP3, you do not need to apply SP3a

First sentance of the link you posted under Overview.

[admin]

Yea thats what I thoght as well, but then I was seeing hugh 80 to 100MB spikes coming out of the system. So I would rater be safe then sorry..

SP3 is on all the systems has been for a long time now, but after we saw a slammer worm get in on a colo we have been watching them very close.

[dlrmartin]

ok, may be 8/27/2003 be a new SP3a revision, but SP3a is from 5/20/2003... see: http://www.microsoft.com/sql/downloads/2000/sp3.asp

Besides, slammer virus is in the road from January, before sp3a. Ms has security patch for slammer since...
see: www.microsoft.com/sql/slammer


BTW, dont worry now about. But try to keep servers up to date.

[admin]

Well I was trying to be safe I know what MS sites said but we all know how well there patachs and fixes really work.. So I wanted to be 100% sure..

[dlrmartin]

Im sure about that.

Thanks for your effort.