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?

[Webinar] Streamline your web hosting managementRegister Today

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
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
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
All Courses

From novice to tech pro — start learning today.