SP4 upgrade ?

Hello Everyone,

I'm in the process of upgrading my SQL 2000 from SP3 to SP4.  I've read
Microsoft's technical versions of their Readme's, however can someone
provide me with a link to a better resource when applying SP4 to their SQL
2000 server?  I would like information about restore procedures if SP4 bombs
my SQL server, things like that.

Thank you
Alex Anderson

Hi

None that I am aware of.
Basics like back up every database before you run the upgrade are in order.
Test on a test server before doing it on production.
Test on another test server again before doing it on production.
Test your application for compatibility.

If it goes totally belly-up. Re-install SQL Server. I have done over 100 Sp4
installs, each one went perfectly.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Alex Anderson" <AAnderson@Murrieta.org> wrote in message
news:OVazrqc9FHA.2696@TK2MSFTNGP11.phx.gbl...
> Hello Everyone,
>
>    I'm in the process of upgrading my SQL 2000 from SP3 to SP4.  I've read
> Microsoft's technical versions of their Readme's, however can someone
> provide me with a link to a better resource when applying SP4 to their SQL
> 2000 server?  I would like information about restore procedures if SP4
> bombs my SQL server, things like that.
>
> Thank you
> Alex Anderson
>
>

Mike,

Thank you for the information.  I unfortunately don't have the luxury of
testing non-production.  I'll just have to rely on my backups in this
matter.  Thanks again.

Thank you
Alex Anderson

"Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
news:uDLFL2f9FHA.648@TK2MSFTNGP12.phx.gbl...
> Hi
>
> None that I am aware of.
> Basics like back up every database before you run the upgrade are in
> order.
> Test on a test server before doing it on production.
> Test on another test server again before doing it on production.
> Test your application for compatibility.
>
> If it goes totally belly-up. Re-install SQL Server. I have done over 100
> Sp4 installs, each one went perfectly.
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@epprecht.net
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "Alex Anderson" <AAnderson@Murrieta.org> wrote in message
> news:OVazrqc9FHA.2696@TK2MSFTNGP11.phx.gbl... 
>
>