Re: installing the latest SQL Server service pack on SBS by Cris
Cris
Fri Dec 07 12:52:56 PST 2007
This is a multi-part message in MIME format.
------=_NextPart_000_00F3_01C838E0.DA76FD00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
SP4 for SQL has been out for quite a while...and I don't think you'll =
have any issues...remember that it will also need to update MSDE =
instannces
--=20
Cris Hanna [SBS-MVP]
-------------------------------------------------
Microsoft MVPs
Independent Experts (MVPs do not work for MS)
Real World Answers
---------------------------------------------------------
Please do not contact me directly regarding issues
"Brad Pears" <bradp@truenorthloghomes.com> wrote in message =
news:%23ifQtqQOIHA.3816@TK2MSFTNGP04.phx.gbl...
Thanks...
Actually at this point, we are not really using SQL Server on our SBS =
box=20
very much at all. I am using it as a test environment for our .NET =
apps that=20
use SQL Server (we have a separate "live" Windows 2000 SQL server box =
but I=20
do not want Shavliks patch DB on that machine) and it is also being =
used for=20
our Blackberry Enterprise Server db and that is it. So I should be =
good to=20
go really. However, I will pose the question to blackberry to make =
sure that=20
their stuff will still run on SP4.
Thanks for the help.
Brad
"Dave Stoecker" <david_stoecker@hotCOFFEEmail.com> wrote in message=20
news:uRXccaQOIHA.4752@TK2MSFTNGP05.phx.gbl...
>
> "Brad Pears" <bradp@truenorthloghomes.com> wrote in message=20
> news:%23kHOszPOIHA.5360@TK2MSFTNGP03.phx.gbl...
>> We have Shavlik Netchk Protect ver 5.9 that allows you to use a =
remote=20
>> SQL Server DB for the backend. The product is much more robust when =
>> configured this way.
>>
>> Before configuring however, I need to upgrade our instance of SQL =
Server=20
>> installed on the SBS to at least SP3. A quick search tells me that =
the=20
>> latest SQL Server 2000 service pack is SP4.
>>
>> When I looked at the MS documentation for the service pack, it did =
not=20
>> list Small Business Server 2000 in teh list of "supported operating =
>> systems".
>>
>> Can someone confirm for me if it will be ok to download and install =
SP4=20
>> on our Windows 2000 SBS machine?
>>
>> Thanks, Brad
>>
>
> It should be no problem, but since I have no knowledge of what =
software=20
> you might be running that uses the SQL instance, I would just point =
out=20
> that you should research any "gotchas" that could occur with said =
software=20
> when upgrading the DBMS.
>
> DS
>=20
------=_NextPart_000_00F3_01C838E0.DA76FD00
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.3199" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>SP4 for SQL has been out for quite a =
while...and I=20
don't think you'll have any issues...remember that it will also need to =
update=20
MSDE instannces</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><BR>-- <BR>Cris Hanna=20
[SBS-MVP]<BR>-------------------------------------------------<BR>Microso=
ft=20
MVPs<BR> Independent Experts (MVPs do not work for MS)<BR>Real =
World=20
Answers<BR>---------------------------------------------------------<BR>P=
lease=20
do not contact me directly regarding issues<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Brad Pears" <<A=20
=
href=3D"mailto:bradp@truenorthloghomes.com">bradp@truenorthloghomes.com</=
A>>=20
wrote in message <A=20
=
href=3D"news:%23ifQtqQOIHA.3816@TK2MSFTNGP04.phx.gbl">news:%23ifQtqQOIHA.=
3816@TK2MSFTNGP04.phx.gbl</A>...</DIV>Thanks...<BR><BR>Actually=20
at this point, we are not really using SQL Server on our SBS box =
<BR>very much=20
at all. I am using it as a test environment for our .NET apps that =
<BR>use SQL=20
Server (we have a separate "live" Windows 2000 SQL server box but I =
<BR>do not=20
want Shavliks patch DB on that machine) and it is also being used for =
<BR>our=20
Blackberry Enterprise Server db and that is it. So I should be good to =
<BR>go=20
really. However, I will pose the question to blackberry to make sure =
that=20
<BR>their stuff will still run on SP4.<BR><BR>Thanks for the=20
help.<BR><BR>Brad<BR><BR><BR>"Dave Stoecker" <<A=20
=
href=3D"mailto:david_stoecker@hotCOFFEEmail.com">david_stoecker@hotCOFFEE=
mail.com</A>>=20
wrote in message <BR><A=20
=
href=3D"news:uRXccaQOIHA.4752@TK2MSFTNGP05.phx.gbl">news:uRXccaQOIHA.4752=
@TK2MSFTNGP05.phx.gbl</A>...<BR>><BR>>=20
"Brad Pears" <<A=20
=
href=3D"mailto:bradp@truenorthloghomes.com">bradp@truenorthloghomes.com</=
A>>=20
wrote in message <BR>> <A=20
=
href=3D"news:%23kHOszPOIHA.5360@TK2MSFTNGP03.phx.gbl">news:%23kHOszPOIHA.=
5360@TK2MSFTNGP03.phx.gbl</A>...<BR>>>=20
We have Shavlik Netchk Protect ver 5.9 that allows you to use a remote =
<BR>>> SQL Server DB for the backend. The product is much more =
robust=20
when <BR>>> configured this way.<BR>>><BR>>> Before=20
configuring however, I need to upgrade our instance of SQL Server =
<BR>>>=20
installed on the SBS to at least SP3. A quick search tells me that the =
<BR>>> latest SQL Server 2000 service pack is=20
SP4.<BR>>><BR>>> When I looked at the MS documentation for =
the=20
service pack, it did not <BR>>> list Small Business Server 2000 =
in teh=20
list of "supported operating <BR>>> =
systems".<BR>>><BR>>>=20
Can someone confirm for me if it will be ok to download and install =
SP4=20
<BR>>> on our Windows 2000 SBS machine?<BR>>><BR>>> =
Thanks,=20
Brad<BR>>><BR>><BR>> It should be no problem, but since I =
have no=20
knowledge of what software <BR>> you might be running that uses the =
SQL=20
instance, I would just point out <BR>> that you should research any =
"gotchas" that could occur with said software <BR>> when upgrading =
the=20
DBMS.<BR>><BR>> DS<BR>> <BR><BR></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_00F3_01C838E0.DA76FD00--