Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Restore sqlserver 6.5 backup to sqlserver 7

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-12-04 : 09:12:11
john writes "I have a backup of a database(sqlserver 6.5 running in NT) and while trying to restore the database in sqlserver 7(in windows 98) it gives me error as to upgraddb.cpp line 195..Array_LEN.....
Please help me to restore the database as it is very important thanx
john"

efelito
Constraint Violating Yak Guru

478 Posts

Posted - 2001-12-04 : 16:41:13
You'll have to restore the database to a SQL 6.5 server, then use the database upgrade wizard to move it to a 7.0 server.

Jeff Banschbach
Consultant, MCDBA
Go to Top of Page

penumatsa
Constraint Violating Yak Guru

289 Posts

Posted - 2001-12-04 : 18:07:20
You cannot restore a SQL 6.5 backup on SQL 7. Thats due to the huge changes made on SQL 7.

suresh penumatsa
Go to Top of Page
   

- Advertisement -