|
Home > Archive > MS SQL Server > October 2006 > Upgrading O/S
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]
|
|
| Paul Bergson [MVP-DS] 2006-10-24, 6:38 pm |
| Are there any pitfalls to upgrading a sql server 2000 with W2K sp4 to W2K3
sp1?
--
Paul Bergson
MVP - Directory Services
MCT, MCSE, MCSA, Security+, BS CSci
2003, 2000 (Early Achiever), NT
http://www.pbbergs.com
Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.
| |
| John Bell 2006-10-24, 6:38 pm |
| Hi Paul
In general you should be fine, there are a few things like
http://support.microsoft.com/kb/839279 which you should be aware of. If you
are moving the database then make sure that your logins will transfer ok and
you don't get orphaned users see http://support.microsoft.com/kb/314546. If
you rename the server make sure that you change the instance name
http://msdn.microsoft.com/library/d...r8f
.asp.
Other things to check would be full text catalogs which would need rebuilding
and if you use replication/log shipping then you would need to make sure they
worked or remove/reconfigure them.
Of course the best thing to do is have a trial run and do a thorough test on
the new platform before going live!
John
"Paul Bergson [MVP-DS]" wrote:
> Are there any pitfalls to upgrading a sql server 2000 with W2K sp4 to W2K3
> sp1?
>
> --
> Paul Bergson
> MVP - Directory Services
> MCT, MCSE, MCSA, Security+, BS CSci
> 2003, 2000 (Early Achiever), NT
>
> http://www.pbbergs.com
>
> Please no e-mails, any questions should be posted in the NewsGroup
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
>
|
|
|
|
|