Solved

Restore database error

Posted on 2001-06-25
6
255 Views
Last Modified: 2010-05-18
I am trying to restore like this

RESTORE DATABASE RiggersCommunity FROM DISK='D:\RigRent\Riggers\RiggersCommunity.bak'
WITH MOVE 'RiggersCommunity_Data' TO 'C:\MSSQL7\data\RiggersCommunity_Data.MDF',
MOVE 'RiggersCommunity_Log' TO 'C:\MSSQL7\data\RiggersCommunity_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...
0
Comment
Question by:Yog
  • 3
  • 3
6 Comments
 
LVL 2

Expert Comment

by:sefa
ID: 6227238
From where are running this command.
0
 
LVL 5

Author Comment

by:Yog
ID: 6227332
I am running this from Query analyser - being in th master database..lol

0
 
LVL 2

Accepted Solution

by:
sefa earned 50 total points
ID: 6227579
It as strange error,
Have you tried to run from another client or from server on itself.You may have a corrupted tool.

Listening & learning.
0
Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

 
LVL 5

Author Comment

by:Yog
ID: 6227815
hi this was as i tried to restore a 2000 backup in a sql7.0 machine.., thanks so much ..and in the meantime i will be thankful to know if this can be done or not..
0
 
LVL 2

Expert Comment

by:sefa
ID: 6227957
Hymm.
As I know a 2000 backup to 7.0 is not possiable even
restore between different versions are impossible.

0
 
LVL 5

Author Comment

by:Yog
ID: 6228000
sefa,

  will be thankful if i know a good best book for sqlserver administration..i can buy just one..thanks so much

yog
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

708 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

12 Experts available now in Live!

Get 1:1 Help Now