mssql 6.5 - restore to fresh server 
Author Message
 mssql 6.5 - restore to fresh server
Hi all,

I have been working with 2000 a bit, and now I am helping someone with a 6.5 server.

How do I restore a backup to a fresh server?   It wants me to pick a destination database.  do I have to create an empty one first?

Also, can I restore it to Mssql 2000?  when I try using EM, I get "Error 3242: The file on device c:\temp\snet.dat is not a valid MS
Tape Format backup set.  RETORE HEADERONLY is terminating abnormally."

Carl Karsten


Tue, 27 Sep 2005 15:08:56 GMT
 mssql 6.5 - restore to fresh server


With 6.5 the database has to exist and it has to have been
built in exactly the same way.

What you need is the output from sp_help_revdatabase. Run
that against the 6.5 database and you will get an output
script that you can use to build an empty database ready
for the restore.



Tue, 27 Sep 2005 15:52:23 GMT
 [ 2 post ] 

 Relevant Pages 

1. Backup in MSSQL 6.5 and restore to MSSQL 7.0

2. Restoring 6.5 backup to 7.0 w/o 6.5 Server

3. systypes in mssql compatibility mode for mssql 6.5?

4. import/export MSSQL 6.5 and MSSQL 7.0

5. upgrade of MSSQL 6.5 to MSSQL 2000

6. set mssql 7.0 compatible to mssql 6.5?

7. compare mssql 6.5 database and mssql 7.0 database

8. Administering MSSQL 6.5 using EM from MSSQL 7.0

9. Drop table error in MSSQL 6.5 and MSSQL 2000

10. Administerring MsSQL 6.5 using EM from MSSQL 7.0?

11. BACKUP then restore to a fresh installation

Powered by phpBB® Forum Software