Microsoft KB Archive/154164

= FIX: TEXT Operations Can AV During DUMP DATABASE =

Article ID: 154164

Article Last Modified on 10/3/2003

-

APPLIES TO


 * 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:


 * 1) Missing "The current contents of process' input buffer" in the error log.
 * 2) The current contents of process' input buffer are '0'.
 * 3) The current contents of process' input buffer are '[ '.

Additional query words: dump AV access violation

Keywords: kbbug kbfix kbnetwork KB154164

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.