https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/170090&feed=atom&action=history
Microsoft KB Archive/170090 - Revision history
2024-03-29T07:36:05Z
Revision history for this page on the wiki
MediaWiki 1.39.3
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/170090&diff=89493&oldid=prev
3155ffGd: importing KB archive
2020-07-18T15:34:59Z
<p>importing KB archive</p>
<p><b>New page</b></p><div><div id="nsbanner"><br />
<br />
<div id="bannerrow1"><br />
<br />
{|<br />
| Knowledge Base<br />
|<br />
|}<br />
<br />
<br />
</div><br />
<div id="TitleRow"><br />
<br />
= <span id="KB170090"></span>FIX: Recovery May Fail w/Error 6902 and Mark Database as Suspect =<br />
<br />
<br />
</div><br />
<br />
</div><br />
<div id="nstext" valign="BOTTOM"><br />
<br />
Article ID: 170090<br />
<br />
Article Last Modified on 10/16/2003<br />
<br />
<br />
-----<br />
<br />
APPLIES TO<br /><br />
<br /><br />
<br />
* Microsoft SQL Server 6.5 Standard Edition<br />
<br />
<br />
-----<br />
<br />
<div class="notice_section"><br />
<br />
This article was previously published under Q170090<br />
<br />
</div><br />
<div class="notice_section"><br />
<br />
BUG #: 16964 (6.5)<br />
<br />
</div><br />
<div class="symptoms_section"><br />
<br />
== SYMPTOMS ==<br />
<br />
LOAD TRAN or recovery may fail with the following error and mark the database as suspect if UPDATETEXT was used to insert at least two text/image pages into the middle of an existing text/image column:<br /><br />
<br />
<div class="errormessage"><br />
<br />
6902 21 Page timestamp value falls between the old and new timestamps<br /><br />
from log. Page #=%ld, object id = %ld, page timestamp=%04x %08lx. Log:<br /><br />
old timestamp=%04x %08lx, new timestamp=%04x %08lx.<br />
<br />
</div><br />
<br />
</div><br />
<div class="cause_section"><br />
<br />
== CAUSE ==<br />
<br />
When processing an UPDATETEXT statement that would insert one or more pages, the timestamp on the first page after the newly inserted pages is not changed until all pages are inserted. On recovery, SQL Server checks the timestamps before making any change on a page, which causes the problem.<br />
<br />
</div><br />
<div class="workaround_section"><br />
<br />
== WORKAROUND ==<br />
<br />
To work around this problem, avoid using UPDATETEXT to insert data into the middle of existing text/image pages. However, UPDATETEXT works fine if new data is appended to the end rather than inserted into the middle.<br />
<br />
</div><br />
<div class="status_section"><br />
<br />
== STATUS ==<br />
<br />
Microsoft has confirmed this to be a problem in SQL Server version 6.5. This problem was corrected in the latest Microsoft SQL Server 6.5 U.S. Service Pack. For information on obtaining the service pack, query on the following word in the Microsoft Knowledge Base (without the spaces):<br /><br />
<br />
<pre class="fixed_text"> S E R V P A C K<br />
</pre><br />
<br />
</div><br />
<br /><br />
<br />
Additional query words: tlog database wrong begin incomplete rollback forward abort<br />
<br />
Keywords: kbbug kbfix kbusage KB170090<br />
<br />
<div class="footer"><br />
<br />
<br /><br />
<br />
<br />
-----<br />
<br />
[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]<br />
<br />
<span>© Microsoft Corporation. All rights reserved.</span><br />
<br />
<br />
</div><br />
<br />
</div></div>
3155ffGd