FIX: Access Violation During the Load of a Read-Only Database (159358)


The information in this article applies to:

  • Microsoft SQL Server 6.0
  • Microsoft SQL Server 6.5
This article was previously published under Q159358
BUG #: 15568 (6.5)

SYMPTOMS

An access violation (AV) may infrequently occur when issuing a LOAD DATABASE or LOAD TRANSACTION command on a database that is read-only.

WORKAROUND

Re-create the database and reload it using the same database dump file. In the case of an access violation during a LOAD TRANSACTION, reload the last database dump and the succeeding transaction log dumps.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 6.0 and 6.5. 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

The problem occurs very infrequently, and only when the database is read- only. It is believed to be more likely if the server has been stopped and started multiple times, or has otherwise undergone startup transactional recovery with the read-only database.
Modification Type:MajorLast Reviewed:10/16/2003
Keywords:kbBug kbenv kbfix KB159358
©2003 Microsoft Corporation. All rights reserved.