asked on

SQL Server question..please help

SQL Server got corrupted and i reinstalled

I am trying to restore like this

RESTORE DATABASE RC FROM DISK='D:\RC.bak'
WITH MOVE 'RC_Data' TO 'C:\MSSQL7\data\RC_Data.MDF',
MOVE 'RC_Log' TO 'C:\MSSQL7\data\RC_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... Have no points now, but i promise i wil provide more poings for the answer

thanks so much

ASKER CERTIFIED SOLUTION

weesiong

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Yog

ASKER

hi thank you, but i am restoring it for the first time from backup, so its giving a message

Server: Msg 155, Level 15, State 3, Line 1
'RECOVERY' is not a recognized RESTORE option.

any idea please, thank you..

weesiong

Yoq,

Ouch... then i donno, i am no meet this problem before, try to post in SQL Server topic :)

Regards,
Wee Siong

Yog

ASKER

yeah ok i understand - have posted one in sql topic also..

cheers

jcs_clement

listening !!

rgds
jcs

Yog

ASKER

Hi, thanks all ..just as i guessed , it was due to restoring the 2000 backup to a sql7.0 database..i am through with this now..and as my points increase i promise to share the points..

cheers

weesiong

Yog

ASKER

thanks guys, jcs added a question seperate for you buddy
cheers :)