SQL Server Performance Forum – Threads Archive
Moving SQL to Win2003 from Win2KWe are planning to move SQL 2000 to Window 2003 server. Do i have to take care anything so that i should not get into mess after moving to Window2003 server from windows2000 advance server. Please provide your inputs.
Thanks and Regards
I suggest to install Windows 2003 afresh rather than going for an upgrade of operating system and it is an easy solution to move databases once operating system is in good state. Search under this forum for moving databases solutions and tips. Refer under Windows 2003 tips link on this website homepage andhttp://www.microsoft.com/sql/howtobuy/windowsnetsupport.asp for information. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Another thing you must consider SQL SERVER doesn’t work without installing SP on Windows 2003, so please intall SP , sp4 is not recomended because still it having some problem so install sp3a. Regards. hsGoswami
And read this if you use MSDTC: