Gurus,
I am trying to migrate a database from sql server 6.5 to sql server 7.0. I was trying to export this database, but I was not able to do it because I encountered a bunch of errors. Now I am trying to restore the same database to a dev server that has sql server 7.0 installed. I also encountered the following error:

Server: Msg 3242, Level 16, State 1, Line 1
The file on device 'D:\ftp downloads\RMS\riskmaster.dat' is not a valid Microsoft Tape Format backup set.
Server: Msg 3013, Level 16, State 1, Line 1
Backup or restore operation terminating abnormally.

I am not using a tape to restore, I have my file on my D drive.

Here's is the syntax that I am using to restore the db.

RESTORE DATABASE RISKMASTER
FROM DISK = 'D:\ftp downloads\RMS\riskmaster.dat'


Is it possible to restore a db from 6.5 to 7.0? Please advise with best method to performance this migration.

Thanks,


Mery B. Moreno
Database Administrator - DBA
Lakeland Regional Medical Center
Phone: 863-687-1100 Ext 2830

BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Moreno, Mery
ORG:;I.S.
EMAIL;WORK;PREF:Mery.[Email address protected]
N:Moreno;Mery
TITLE:DBA
END:VCARD


MS Sql Server LazyDBA home page