I attempted to upgrade to SQL Server 2000 from SQL Server 6.5 using
the SQL Server Upgrade Wizard and I immediately received the following
error message:

An unknown error occurred while trying to restart your SQL Server
2000. Please check the server errorlog and try again.

I've checked the SQL Server log and all of the logs available in the
Event Viewer and I don't see anything remarkable in any of them. Does
anyone have any suggestions for how to proceed?

(bob.ward (AT) enron (DOT) com) writes:
It may be easier to run without the wizard. (I the days we migrated from
6.5, I never used the wizard myself.)

If you don't have the scripts for your databases under version control,
use the script-generation facility in the 6.5 Enterprise Manager. Then
run these scripts in SQL 2000.

For the data do:

SELECT 'bcp ' + db_name() + '..' + name + ' format ' + name +
'.bcp -n -U sa -P secretpw -S SERVER65 -f ' + name + '.fmt'
FROM sysobjects
WHERE type = 'U'
ORDER BY name

Run, save result in a BAT file and rnu BAT file. Change "format" to
out and run again, and again run result as BAT file.

SELECT 'bcp ' + db_name() + '..' + name + ' in ' + name +
'.bcp -n -E -U sa -P secretpw -S SERVER2000 -f ' + name + '.fmt'
FROM sysobjects
WHERE type = 'U'
ORDER BY name

Again run result as a BAT file.

Left to migrate is logins, users and permissions. This I don't have
anything canned for.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx