BUG: DBCC OPENTRAN Fails to Run on Fallback Server (188330)



The information in this article applies to:

  • Microsoft SQL Server 6.5

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.

Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbBug kbpending KB188330