Yog
asked on
Restore database error
I am trying to restore like this
RESTORE DATABASE RiggersCommunity FROM DISK='D:\RigRent\Riggers\R iggersComm unity.bak'
WITH MOVE 'RiggersCommunity_Data' TO 'C:\MSSQL7\data\RiggersCom munity_Dat a.MDF',
MOVE 'RiggersCommunity_Log' TO 'C:\MSSQL7\data\RiggersCom munity_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...
RESTORE DATABASE RiggersCommunity FROM DISK='D:\RigRent\Riggers\R
WITH MOVE 'RiggersCommunity_Data' TO 'C:\MSSQL7\data\RiggersCom
MOVE 'RiggersCommunity_Log' TO 'C:\MSSQL7\data\RiggersCom
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...
From where are running this command.
ASKER
I am running this from Query analyser - being in th master database..lol
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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..
Hymm.
As I know a 2000 backup to 7.0 is not possiable even
restore between different versions are impossible.
As I know a 2000 backup to 7.0 is not possiable even
restore between different versions are impossible.
ASKER
sefa,
will be thankful if i know a good best book for sqlserver administration..i can buy just one..thanks so much
yog
will be thankful if i know a good best book for sqlserver administration..i can buy just one..thanks so much
yog