?
Solved

SQL Server question..please help

Posted on 2001-06-25
8
Medium Priority
?
278 Views
Last Modified: 2008-03-10
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
0
Comment
Question by:Yog
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 7

Accepted Solution

by:
weesiong earned 200 total points
ID: 6226226
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
 
LVL 5

Author Comment

by:Yog
ID: 6226237
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
 
LVL 7

Expert Comment

by:weesiong
ID: 6226247
Yoq,

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

Regards,
Wee Siong
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 5

Author Comment

by:Yog
ID: 6226272
yeah ok i understand - have posted one in sql topic also..

cheers
0
 
LVL 4

Expert Comment

by:jcs_clement
ID: 6226290
listening !!

rgds
jcs
0
 
LVL 5

Author Comment

by:Yog
ID: 6227810
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
 
LVL 7

Expert Comment

by:weesiong
ID: 6229853
:)
0
 
LVL 5

Author Comment

by:Yog
ID: 6308065
thanks guys, jcs added a question seperate for you buddy
cheers :)
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question