Knowledge Base

BUG: DBCC OPENTRAN Fails to Run on Fallback Server

Article ID: 188330

Article Last Modified on 10/3/2003

APPLIES TO

This article was previously published under Q188330
BUG #: 18019 (SQLBUG_65)

SYMPTOMS

If a database enrolled in fallback support is currently on the fallback server, DBCC OPENTRAN will not return any results.

WORKAROUND

To work around this problem, do either of the following:

  • Make sure that the dbids of the databases enrolled for fallback are not in use on the fallback server. -or-

  • Move the database back to the primary server and then run DBCC OPENTRAN on the database.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: prodsql failover 1105 transaction log

Keywords: kbbug kbpending KB188330


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.