Knowledge Base

PRB: Interrupting Transaction Log Load Requires Database Reload

Article ID: 186849

Article Last Modified on 10/3/2003

APPLIES TO

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


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.