|
Home > Archive > MS SQL Server > November 2005 > SP4 upgrade ?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Alex Anderson 2005-11-30, 11:23 am |
| 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 Epprecht \(SQL MVP\) 2005-11-30, 8:23 pm |
| 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
>
>
| |
| Alex Anderson 2005-11-30, 8:23 pm |
| 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...
>
>
|
|
|
|
|