Unanswered: sql 6.5 upgrade to sql 2000! pls help me!!!
hi,I want to use the "dump/load" to upgrade sqlserver6.5 to sqlserver200.
when I use the follow command to dump database on sqlserver 6.5 (nt4):
dump database cwfx to disk='c:\back\cwfx.dup'.
then I copy the file "cwfx.dup" to another computer ( windows 2000 ), and load it into sqlserver 2000 :
load database cwfx from disk='c:\cwfx.dup'
the follow is the error:
Server: Msg 3242, Level 16, State 1, Line 1
The file on device 'c:\cwfx' is not a valid Microsoft Tape Format backup set.
Server: Msg 3013, Level 16, State 1, Line 1
Backup or restore operation terminating abnormally.