Knowledge Base

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\SQL0000X.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.

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.

REFERENCES

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

264474 PRB: System Database Backups Cannot be Restored on a Different Build of SQL Server

261334 INF: Frequently Asked Questions - SQL Server 2000 - Upgrade

322620 INF: How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000 (White Paper)

321185 HOW TO: Identify Your SQL Server Service Pack Version and Edition

Keywords: kbbug kbserver kbdatabase kbprb kbbackup KB824423

Microsoft KB Archive/824423

Contents

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

SYMPTOMS

CAUSE

WORKAROUND

REFERENCES