Mery,
You can not restore from 6.5 to 7.0. You have to do a conversion.

-----Original Message-----
From: Mery Moreno
[mailto:mssqldba-ezmlmshield-x69314783.[Email address protected]
Sent: Wednesday, August 25, 2004 10:05 AM
To: LazyDBA Discussion
Subject: Migrate from 6.5 to 7.0


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



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


MS Sql Server LazyDBA home page