help on restore the database - SQL Server Forums

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)

help on restore the database

Author

Topic

april
Starting Member

2 Posts

Posted - 2003-03-06 : 10:38:46

I tried to restore the database from a dump file and got the following error message:

Server: Msg 3624, Level 20, State 1, Line 1

Location: upgraddb.cpp:214
Expression: tableIndex < ARRAY_LEN (upgradeMap)
SPID: 12
Process ID: 128

Connection Broken

What shall I do? Change the table Index?
Thanks,

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-03-06 : 12:56:34

I have never seen an error message like that while performing a restore. What version of SQL Server are you using? 6.5? "Dump file" is a term from 6.5, so that's why I'm asking. Anyway, I would suggest doing DBCC CHECKDB(DBName) on your database to verify its integrity.

Tara

april
Starting Member

2 Posts

Posted - 2003-03-06 : 13:37:54

I am using SQL server 7.0 in one server using this command to get the dump file:
dump database dbWill to disk='\\ldihouinf18\\dbWill.bak' with init

Then I copied this .bak file to another directory and used the following command to restore in another server, it gave me the error message:
restore database dbwill from disk='D:dbWill.bak' with replace

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-03-06 : 13:43:50

Just so that you know, the dump command is available in SQL 7.0 for backward compatibility. You should be using BACKUP/RESTORE instead of DUMP/LOAD.

Is that really your restore command? The path information of the file is incorrect. Have you done DBCC CHECKDB(DBName) on the original server to verify the database's integrity?

Tara

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2003-03-07 : 04:39:58

Are you restoring database across different versions of SQL Server by any chance?
It's not possible to restore a SQL Server 2K to a SQL Server 7 or 6.5 version.
If this is not your case better to open a ticket with Microsoft Support.
HTH

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-03-07 : 12:50:53

Even if april was trying to restore a 6.5 database to 7.0 or 2k, the restore wouldn't be getting these errors.

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources