SYMPTOMS
In Microsoft SQL Server 2000 Service Pack 3 (SP3), when you try to restore a database backup, the
restoration may fail, and a retail assertion with error 3624 may occur. You may
see an error message that is similar to the following in the SQL Server error log
files as a result of the assertion error:
SQL Server
Assertion: File: <xdes.cpp>, line=9860
Failed Assertion =
'IS_OFF_SAFE (XDES_OUTCOME_ONLY, m_status)'
This problem occurs
when all the following conditions are true:
- You take the database backup from a Microsoft SQL Server 7.0
database.
- While you take the database backup, transactions that involve
multiple databases are logged in the transaction logs.
- You restore the database backup in Microsoft SQL Server
2000.
RESOLUTION
Service pack information
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
290211 How to obtain the latest SQL Server 2000 service pack
Hotfix information
The English version of this fix has
the file attributes (or later) that are listed in the following table. The
dates and times for these files are listed in coordinated universal time (UTC).
When you view the file information, it is converted to local time. To find the
difference between UTC and local time, use the
Time Zone tab in the Date and Time tool in Control Panel.
Date Time Version Size File name
--------------------------------------------------------------------------
07-Feb-2003 16:14 786,432 bytes Distmdl.ldf
07-Feb-2003 16:14 2,359,296 bytes Distmdl.mdf
29-Jan-2003 12:25 180 bytes Drop_repl_hotfix.sql
31-Jan-2003 11:02 2000.80.763.0 1,557,052 bytes Dtsui.dll
29-Jan-2003 12:25 1,402 bytes Inst_repl_hotfix.sql
07-Feb-2003 17:10 2000.80.765.0 90,692 bytes Msgprox.dll
29-Jan-2003 11:48 7.0.9466.0 344,064 bytes Msvcr70.dll
29-Jan-2003 11:48 2000.80.722.0 57,904 bytes Osql.exe
29-Jan-2003 15:48 746,470 bytes Instdist.sql
07-Feb-2003 14:23 1,065,895 bytes Replmerg.sql
07-Feb-2003 17:10 2000.80.765.0 221,768 bytes Replprov.dll
07-Feb-2003 17:10 2000.80.765.0 307,784 bytes Replrec.dll
29-Jan-2003 15:48 1,084,318 bytes Replsys.sql
29-Jan-2003 11:48 2000.80.534.0 127,548 bytes Sqdedev.dll
29-Jan-2003 11:48 2000.80.194.0 180,290 bytes Sqlunirl.dll
07-Feb-2003 17:10 2000.80.765.0 176,696 bytes Sqlmap70.dll
07-Feb-2003 17:10 2000.80.765.0 57,920 bytes Sqlrepss.dll
07-Feb-2003 17:11 2000.80.765.0 7,528,529 bytes Sqlservr.exe
07-Feb-2003 17:10 2000.80.765.0 45,644 bytes Sqlvdi.dll
07-Feb-2003 17:10 2000.80.765.0 82,492 bytes Ssnetlib.dll
Note Because of file dependencies, the most recent hotfix or feature
that contains these files may also contain additional files.
Important This hotfix build is designed for a server that is
running Microsoft SQL Server 2000 Service Pack 3.