Upgrade from 7.0 to 2000

[lory]

Does anyone know the exact steps that are best to take when upgrading from SQL 7.0 to 2000? Do I do an install of 2000, then restore a 7.0 bak file to upgrade? How to upgrade, is there a wizard? What gotchas are there with upgrading? Thanks for the info in advance.

 

[tlbroadbent]

Upgrading from SL 7 to SQL 2000 is generally painless and simple. I recommend allowing Setup to upgrade the databases. Some prefer detaching user databses and then attaching after the setup completes. Attaching SQL 7 databases in SQL 2000 causes them to be upgraded.

How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000

http://www.microsoft.com/technet/prodtechnol/sql/deploy/upgrdmigrate/sqlugrd.asp

SQL Server 2000 and SQL Server 7.0

http://msdn.microsoft.com/library/en-us/instsql/in_bckwd_3vlc.asp

Preparing to Install SQL Server 2000

http://msdn.microsoft.com/library/psdk/sql/in_overview_0lm4.htm

SQL Server 2000 Upgrade Guide - 3rd party white paper

http://www.asapsoftware.com/microsoft/sql2000/SQL2kUpgradeGuide.zip

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.