Upgrading from SQL 7 on winnt to SQL 2000 on Win2K | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Upgrading from SQL 7 on winnt to SQL 2000 on Win2K

Hi all, I have done upgrades from SQL 7 to SQL 2000 on same platforms before. That is, both were Win2K. This time, I will be upgrading SQL 7 on Winnt to SQL 2000 on Win2K. That is, after the OS upgrade is completed, I will be upgrading the SQL. Is there any issues to watch out for ? Thanks,
Kanthi
On OS part :
Although Microsoft supports upgrading Windows NT server and Server to Windows 2000 Adv.server, you may be better off with a fresh installation. Pay special attention to the Configuration changes made after the Windows 2000 Upgrade is complete. This is by no means a complete list of issues. Refer to this KBAhttp://support.microsoft.com/default.aspx?kbid=296480 for more information. In terms of SQL upgrade as always, suggest to read thru thishttp://www.sqlteam.com/item.asp?ItemID=9066 link for more information.
_________
Satya SKJ
Moderator
SQL-Server-Performance.Com

Came thru these links from my library :
http://www.microsoft.com/technet/tr…dows2000serv/deploy/upgrdmigrate/w2ksrupg.asp – technet link for Server Upgrade to Windows 2000. http://support.microsoft.com/default.aspx?kbid=284246 – upgrade issues. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

In case all these link don’t said: Update Statistics on each database in SQL2k
Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
True, before and after perform DBCC checks in order to cleanup the performance issues. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

]]>