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

ID: Q159358

The information in this article applies to:

Microsoft SQL Server versions 6.0, 6.5

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          : kbenv SSrvGPF kbbug6.50 kbbug6.00 kbfix6.50.sp2 
Version           : 6.0 6.5
Platform          : WINDOWS 
Issue type        :

Last Reviewed: April 4, 1999