Microsoft KB Archive/824423

= PRB: Restore Operation May Fail When You Try to Restore a SQL Server 2000 Database in SQL Server 7.0 =

Article ID: 824423

Article Last Modified on 10/23/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



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 .dmp (where  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.



CAUSE
This problem occurs because the SQL Server 2000 database backup device files are not supported in SQL Server 7.0. The format of the backup device files in SQL Server 7.0 and SQL Sever 2000 is different. Microsoft does not support restoring SQL Server 2000 databases on a computer that is running SQL Server 7.0.



WORKAROUND
To work around this problem, use the data transfer utilities in SQL Server 2000, including Data Transformation Services (DTS) and the BCP utility, or create linked server queries to transfer data from a SQL Server 2000 database to a SQL Server 7.0 database. You can also upgrade from SQL Server 7.0 to SQL Server 2000, and then back up and restore the database on the computer that is running SQL Server 2000 server.

