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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Upgrading to Sql server to windows 2003

Author  Topic 

svicky9
Posting Yak Master

232 Posts

Posted - 2005-12-20 : 04:25:35
Hi Guys

we have one of our Sql servers running on Windows server 2000 and i want to upgrade it to Windows Server 2003.

Are there any precautions you can suggest when i do the upgrade.

Thanks
Vic

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2005-12-20 : 04:33:20
For Windows 2003, you will need at least SP3

-----------------
[KH]

Learn something new everyday
Go to Top of Page

kevindockerty
Starting Member

27 Posts

Posted - 2005-12-20 : 04:52:59
I did this a while ago - it all went fairly smoothly.
But yes get the service pack 3
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-12-20 : 05:36:55
>>Any precautions ?

1. Back up all your data first
2. and script your database



Afrika
Go to Top of Page

bakerjon
Posting Yak Master

145 Posts

Posted - 2005-12-20 : 09:01:41
If you are using Distributed Transactions, you will want to be aware of changes in MSDTC in Win2k3. First it is not network enabled by default. You will have to turn that on. Next if you go with SP1 (recommended) there could be some security concerns with it. See here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=48061



Jon
-Like a kidney stone, this too shall pass.

http://www.sqljunkies.com/weblog/outerjoin
Go to Top of Page
   

- Advertisement -