Microsoft KB Archive/159358

= FIX: Access Violation During the Load of a Read-Only Database =

Article ID: 159358

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition

-



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.

Keywords: kbbug kbfix kbenv KB159358

-

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

© Microsoft Corporation. All rights reserved.