Knowledge Base

FIX: TEXT Operations Can AV During DUMP DATABASE

Article ID: 154164

Article Last Modified on 10/3/2003

Microsoft SQL Server 6.5 Standard Edition

This article was previously published under Q154164

SYMPTOMS

Attempting to dump a database while a dbwritetext, dbmoretext, or WRITETEXT is being executed on one of the tables in the database may cause a handled access violation (AV) followed by a SQL Server hang. A partial dump is created, and the loading header from the dump shows the dumpsize to be 0 (0 pages). It may not be possible to shut down SQL Server under these conditions. In order to restart SQL Server, you may have to restart Windows NT.

WORKAROUND

Schedule database dumps so that they do not execute while applications are using text operations such as dbwritetext, dbmoretext, or WRITETEXT.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server NT version 6.5. The problem does not occur in SQL Server NT version 6.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.

MORE INFORMATION

This behavior can often be seen while dumping the SMS database, because SMS EXECUTIVE continuously uses WRITETEXT on the InstructionData image field in the Jobs table. The WRITETEXT operation does not get reported in the error log, and various data concerning the contents of the process input buffer may be seen, including the following:

Missing "The current contents of process' input buffer" in the error log.
The current contents of process' input buffer are '0'.
The current contents of process' input buffer are '[ '.

Additional query words: dump AV access violation

Keywords: kbbug kbfix kbnetwork KB154164