BUG: DBCC OPENTRAN Fails to Run on Fallback Server

ID: Q188330

The information in this article applies to:

• Microsoft SQL Server version 6.5

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
Solution Type     : kbpending

Last Reviewed: July 4, 1998