PRB: Interrupting Transaction Log Load Requires Database Reload (186849)


The information in this article applies to:

  • Microsoft SQL Server 6.5
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.
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbnofix kbprb KB186849
©2003 Microsoft Corporation. All rights reserved.