Solved

SQL Server question..please help

Posted on 2001-06-25
8
230 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
  • 4
  • 3
8 Comments
 
LVL 7

Accepted Solution

by:
weesiong earned 50 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
 
LVL 5

Author Comment

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

cheers
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

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…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

757 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now