Re: Can I install SP3a over the existing SP3?

From: SatyaSKJ (SatyaSKJ_at_discussions.microsoft.com)
Date: 07/05/04 

Date: Mon, 5 Jul 2004 06:21:01 -0700

Because most changes introduced in SP3a are related to Setup, you do not need to apply SP3a to instances of SQL Server 2000 or MSDE 2000 that have already been upgraded to SP3.

If you have instances that have not yet been upgraded to SP3, however, you should always upgrade those instances directly to SP3a instead of SP3.

If you have any copies of the SP3 download files that you were planning to use for future upgrades, you should delete those copies and instead use either the SP3a download files or the SP3a CD-ROM. Applications that distribute and install MSDE 2000 should install SP3a instead of SP3.

While you can apply SP3a to instances of SQL Server 2000 SP3 or MSDE 2000 SP3, doing so has little effect on those instances.

"Hari" wrote:

> Hi,
>
> No issues at all. You can very well install SP3a over SP3 in SQL Server
> 2000.
>
> Note:-
>
> If it is production system it is always recommended to apply the SP3a above
> SP3 in test server, test it for couple of days and apply to production.
> --
> Thanks
> Hari
> MCDBA
>
>
> "L Widyanto" <lxwidya@fresno.k12.ca.us> wrote in message
> news:ubY6855XEHA.1652@TK2MSFTNGP09.phx.gbl...
> > I have 2 servers: Win2000 running SQL2000 SP3 and Win2003 running SQL2000
> > SP3a. I need to restore the Master Database from the Win2000 machine to
> the
> > Win2003 machine, but it won't let me since the SQL2000 versions are
> > different. So I need to get the Win2000 machine up to SP3a.
> >
> > Questions: Can I safely install SP3a over SP3? Should I uninstall the
> SP3
> > first? Are there other options out there?
> >
> > - Laurence Widyanto
> >
> >
>
>
>

Relevant Pages

  • Re: Can I install SP3a over the existing SP3?
    ... You can very well install SP3a over SP3 in SQL Server ... If it is production system it is always recommended to apply the SP3a above ... SP3 in test server, test it for couple of days and apply to production. ...
    (microsoft.public.sqlserver.setup)
  • Re: Installing/Moving SQL Server 2000 on to SBS 2003 Standard Edition
    ... I suspected as much but I do not have a test server as yet to confirm. ... SBS2003 requires SQL2000 SP3. ... You will get a warning message when you try ... to install SQL saying SP3 is required. ...
    (microsoft.public.windows.server.sbs)
  • RE: SQL 2000 sp3a on Windows sp4
    ... Are you referring to performance issues? ... apply first on a test server and test your applications with the new sp3a, ...
    (microsoft.public.sqlserver.server)