Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CanadaDBA
583 Posts |
 Posted - 2004-12-03 : 13:59:54
|
| What are the impacts if I upgrade my SQL2000 box from Win2000 to Win2003?Canada DBA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-03 : 15:57:06
|
| Possible impact..you'll have to rebuild SQL Server. We've done several upgrades with no problems but just a little while ago in our test environment the upgrade failed and they had to wipe out the C drive to fix. I had to rebuild SQL Server in order to get it back up and running. So this is a worst case scenario probably. Always have backups when doing something like this. The safest way to do the upgrade is to have two servers, one with win2k and the other with win2k3 then you'd just move your stuff to the new server and be done with the old one.Tara |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-12-05 : 21:35:46
|
| also, you should have sp3a already--------------------keeping it simple... |
|
|
|
CanadaDBA
583 Posts |
Posted - 2004-12-07 : 10:43:25
|
Thanks Tara for sharing the experience. After everything was done, have you encountered any problem? Any? Thanks,Farhadquote:
Originally posted by tduggan
Possible impact..you'll have to rebuild SQL Server. We've done several upgrades with no problems but just a little while ago in our test environment the upgrade failed and they had to wipe out the C drive to fix. I had to rebuild SQL Server in order to get it back up and running. So this is a worst case scenario probably. Always have backups when doing something like this. The safest way to do the upgrade is to have two servers, one with win2k and the other with win2k3 then you'd just move your stuff to the new server and be done with the old one.Tara
Canada DBA |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-07 : 12:19:55
|
| No, we have not encountered any problems after the upgrade.Tara |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-12-07 : 12:51:34
|
| I'm with Tara on this one. An upgrade of any version of Windows is not such a good idea, esp. on mission critical systems.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
CanadaDBA
583 Posts |
Posted - 2005-01-11 : 13:10:50
|
| Thank you all for sharing your experience and ideas. I am agree with installing fresh Win2k3 and not upgrading the Win2k. My manager asked me to research on the Internet and ask those DBAs who have upgraded their Win2k to Win2k3 and see what problems they have encountered. If you have upgraded your Win2000 to Win2003 please share your experience. Also, if you have installed a fresh Win2003, share your experience.We have SQL2000 on Win2000. Before to Production, we have "test" and "dev" servers and we will upgrade/install on them first. Canada DBA |
|
|
|
|
|
|
Upgrade Win2000 to Win2003