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
LVL 5
YogAsked:
Who is Participating?
 
weesiongConnect With a Mentor Commented:
Yoq,

Try using Recovery

RESTORE DATABASE RC FROM DISK='D:\RC.bak' WITH RECOVERY 'RC_Data' TO 'C:\MSSQL7\data\RC_Data.MDF', MOVE 'RC_Log' TO 'C:\MSSQL7\data\RC_Log.LDF'

Regards,
Wee Siong
0
 
YogAuthor Commented:
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..
0
 
weesiongCommented:
Yoq,

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

Regards,
Wee Siong
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

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

cheers
0
 
jcs_clementCommented:
listening !!

rgds
jcs
0
 
YogAuthor Commented:
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
0
 
weesiongCommented:
:)
0
 
YogAuthor Commented:
thanks guys, jcs added a question seperate for you buddy
cheers :)
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.