Restore database error

I am trying to restore like this

RESTORE DATABASE RiggersCommunity FROM DISK='D:\RigRent\Riggers\RiggersCommunity.bak'
WITH MOVE 'RiggersCommunity_Data' TO 'C:\MSSQL7\data\RiggersCommunity_Data.MDF',
MOVE 'RiggersCommunity_Log' TO 'C:\MSSQL7\data\RiggersCommunity_Log.LDF'

Getting the following error

Changed language setting to us_english.
Server: Msg 3624, Level 20, State 1, Line 1
 
Location:      upgraddb.cpp:214
Expression:      tableIndex < ARRAY_LEN (upgradeMap)
SPID:           7
Process ID:      632

Connection Broken

Please help...
LVL 5
YogAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
sefaConnect With a Mentor Commented:
It as strange error,
Have you tried to run from another client or from server on itself.You may have a corrupted tool.

Listening & learning.
0
 
sefaCommented:
From where are running this command.
0
 
YogAuthor Commented:
I am running this from Query analyser - being in th master database..lol

0
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

 
YogAuthor Commented:
hi this was as i tried to restore a 2000 backup in a sql7.0 machine.., thanks so much ..and in the meantime i will be thankful to know if this can be done or not..
0
 
sefaCommented:
Hymm.
As I know a 2000 backup to 7.0 is not possiable even
restore between different versions are impossible.

0
 
YogAuthor Commented:
sefa,

  will be thankful if i know a good best book for sqlserver administration..i can buy just one..thanks so much

yog
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.