FIX: Access Violation May Occur During a LOAD TRANSACTION (174484)
The information in this article applies to:
This article was previously published under Q174484
BUG #: 17269 (WINDOWS: 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 6.5. This problem has been corrected in Service Pack 5a for Microsoft SQL Server 6.5.For more information, click the following article number to view the article in the Microsoft Knowledge Base: 197177 INF: How to Obtain SQL Server 6.5 Service Pack 5a For more information, contact your primary support provider.
MORE INFORMATION
| Modification Type: | Major | Last Reviewed: | 3/14/2006 |
|---|
| Keywords: | kbBug kbfix kbusage KB174484 |
|---|
|