Microsoft KB Archive/186849

= PRB: Interrupting Transaction Log Load Requires Database Reload =

Article ID: 186849

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q186849



sqlbug_65: 17911



SYMPTOMS
If SQL Server stops while it is loading a transaction log, the database is left in an unknown state and you may experience an error 2620 when you restart SQL Server.



CAUSE
During the process of loading a transaction log, database pages are copied and the database is recovered. If this process is interrupted, SQL Server can not guarantee the state of the current database because the reload was not completed.



WORKAROUND
To insure proper database integrity, reload from a known database state.

Additional query words: prodsql

Keywords: kbnofix kbprb KB186849

-

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

© Microsoft Corporation. All rights reserved.