Monday, March 12, 2012

Help !!! Database failed to restore

I had to restore SQl Server v7 but the database has failed to reinstall..

sql statement

restore database sebr from disk = "c:\Projects\EBR\Database" with norecovery, stats=1, replace

Response after about 5 mins

Server: Msg 3624, Level 20, State 1, Line 1
Location: upgraddb.cpp:214
Expression: tableIndex < ARRAY_LEN (upgradeMap)
SPID: 7
Process ID: 800

Connection Broken

Can anybody give any advice ?

Hi!

What SQL version you use to create backup and what version of server where you restore it?

|||Thanks for your reply S.G. - it was the same version (v7.0)|||any SP? If it wont help try to not replace but restore it with the different name and if it help replace these dbs.

No comments:

Post a Comment