BUG: DBCC OPENTRAN Fails to Run on Fallback Server

ID: Q188330

The information in this article applies to:
  • Microsoft SQL Server version 6.5
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 : SSrvAdmin kbbug6.50
Version : winnt:6.5
Platform : winnt
Issue type : kbbug


Last Reviewed: December 14, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.