Restoring a DataBase from SQL 2000 to SQL 7

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 Development (2000)

Restoring a DataBase from SQL 2000 to SQL 7

Author

Topic

edb2003
Yak Posting Veteran

66 Posts

Posted - 2003-09-15 : 18:29:34

Hi,
Not too smart. The company I have a project I backed up a database from SQL 7 to my Database in SQL 2000. No problem however when I restore the database into SQL 7 it fails to back up due to this error .....

Error 3624;
Table Index Array <LEN_ARRAY upgrade Map>
SPID 15
PROCESS ID 118

Can anyone help me with this?

thx bunches :)
Ed

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-09-15 : 18:31:14

You can NOT restore a database from SQL Server 2000 into SQL Server 7.0. It is not backward compatible. If you need to export the data, then you can use bcp, DTS, or INSERT INTO/SELECT FROM.

Tara

edb2003
Yak Posting Veteran

66 Posts

Posted - 2003-09-15 : 18:45:53

Thank you Tara ... I appreciate your input :)

Ed

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources