|
|
Posted by Erland Sommarskog on 03/01/07 22:21
(bob.ward@enron.com) writes:
> 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?
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@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|