Knowledge Base

PRB: Moving Fallback Database Back to Primary Server May Cause Error 913

Article ID: 178345

Article Last Modified on 10/3/2003

Microsoft SQL Server 6.5 Standard Edition

This article was previously published under Q178345

SYMPTOMS

After moving databases back to the primary server, which runs the stored procedure sp_fallback_deactivate_svr_db on the fallback server, executing stored procedures or using views in the databases enrolled for fallback may cause the following error:

Error: 913, Severity: 22, State: 2
Could not find row in Sysdatabases with database id <x>. Run DBCC
CHECKTABLE on Sysdatabases.

CAUSE

The stored procedures or views were used while the database was moved to the fallback server, and the dbid used for the database on the fallback server was not the same as the dbid on the primary server.

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-
Ignore the error 913 because the stored procedure or view is still run correctly.

MORE INFORMATION

To create new databases on the fallback server while it does not control the fallback databases, do the following:

Create temporary databases of any size to use the dbids from the primary server.
Create the new databases.
Drop the temporary databases.

Additional query words: stproc st proc

Keywords: kbprb KB178345