Solved

SQL Server question..please help

Posted on 2001-06-25
8
250 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
Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

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…
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

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