SYMPTOMS
When you try to restore a Microsoft SQL Server 2000 database backup to
a SQL Server 7.0 server, the restore operation may fail. If the
version of SQL Server 7.0 that is running on your computer is 7.00.623, (the base version of SQL Server 7.0), you may receive an error
message that is similar to the following:
Server: Msg 3624,
Level 20, State 1, Line 1
Location: upgraddb.cpp:214
Expression:
tableIndex < ARRAY_LEN (upgradeMap)
SPID: 9
Process ID: 2152
Connection Broken
You may also see stack dump errors
that are similar to the following in the SQL Server error log:
*******************************************************************************
*
* BEGIN STACK DUMP:
* 08/26/03 12:57:12 spid 9
*
* Input
Buffer 226 bytes -
* R E S T O R E D A T A B A S E [ t e s t b a c k u p ]
F R O M D I
* S K = N ' F : \ t e s t b a c k u p ' W I T H F I L E
*
= 1 , N O U N L O A D , S T A T S = 1 0 , R E C O
* V E R Y
*
*******************************************************************************
-------------------------------------------------------------------------------
Short Stack Dump
0x77f96dfb Module(ntdll+16dfb) (NtGetContextThread+b)
0x00778999 Module(sqlservr+378999) (utassert_fail+1a0)
0x007650d2
Module(sqlservr+3650d2) (IsBackupVersionCompatible+57)
0x00708ae5
Module(sqlservr+308ae5) (BackupMedium::ProcessDatabaseConfiguration+21f)
0x007088ab Module(sqlservr+3088ab)
(BackupMedium::ProcessConfigurationStream+132)
0x007086db
Module(sqlservr+3086db) (BackupMedium::ProcessConfiguration+333)
0x00717e08 Module(sqlservr+317e08) (BackupStream::ThreadRoutine+e6)
0x004cc684 Module(sqlservr+cc684) (subproc_main+f4)
0x41092be1
Module(ums+2be1) (ProcessWorkRequests+ed)
0x4109336a Module(ums+336a)
(ThreadStartRoutine+139)
0x7800c9eb Module(MSVCRT+c9eb) (beginthread+ce)
0x77e887dd Module(KERNEL32+87dd) (GetModuleFileNameA+1d1)
0x00000000
Module(sqlservr+ffc00000)
-------------------------------------------------------------------------------
Note For example, the path of the SQL Server error log
on your computer may be C:\MSSQL7\Log\SQL0000
X.dmp (where
X is the incremental
number of the SQL Server error log).
If the version of SQL Server 7.0
that is running on your computer is 7.00.839 (SQL Server 7.0 Service Pack 2 version), you may receive the
following error message:
Server: Msg 3169, Level 16,
State 1, Line 1
The backed-up database has on-disk structure version 539.
The server supports version 515 and cannot restore or upgrade this
database.
Server: Msg 3013, Level 16, State 1, Line 1
Backup or
restore operation terminating abnormally.