I will be attempting to move Sql from an older server running windows 2000 to a newer server running 2003. I have read that you need SQL server sp3 to run it on Windows 2003. We are at SP2. Should I upgrade to SP3 first and then move it to the new server? Or can I install Sql server sp3 on the newer server and then move the data over?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Moving SQL to Windows 2003 Server
- Thread starter DASLG
- Start date
- Thread starter
- #3
Do a search on the forum (this one and the one for programming) for Windows 2003. I don't remember if I saw the issue on this site or another SQL Server site I participate in.
You might also check in Microsoft's Knowledge Base articles and their site for Windows 2003.
Going through the sludge in my brain, I seem to recall the issue was that the upgrade to Win2003 would just fail because SP3 was missing. And you can't apply SP3 after the install because it looks for it before it can complete. Note: This may have been fixed, a lot of people complained about it to Microsoft.
-SQLBill
You might also check in Microsoft's Knowledge Base articles and their site for Windows 2003.
Going through the sludge in my brain, I seem to recall the issue was that the upgrade to Win2003 would just fail because SP3 was missing. And you can't apply SP3 after the install because it looks for it before it can complete. Note: This may have been fixed, a lot of people complained about it to Microsoft.
-SQLBill
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question