FIX: Access Violation May Occur During a LOAD TRANSACTION

• Microsoft SQL Server version 6.5

SYMPTOMS

Loading a transaction log dump may fail with an access violation (AV). The database will be in a loading state after the AV, so it will be unusable in the current session. In some situations, the database will recover successfully upon startup, but a DBCC NEWALLOC statement may report Msg 2529. Otherwise, recovery may fail and the database marked suspect. The errorlog will report the following:

Error: 933, Severity: 22, State: 1

CAUSE

The first data page of a table was empty before the LOAD TRANSACTION statement was issued and a transaction being applied requires the first empty page to be deallocated, making the previous second page now the first page.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 5a for Microsoft SQL Server version 6.5. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

For more information, contact your primary support provider.

MORE INFORMATION

Additional query words: Additional query words: backup restore sp sp3

Keywords          : kbusage SSrvAdmin kbbug6.50 kbfix6.50.SP5 
Version           : winnt:6.5
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: April 21, 1999