Microsoft KB Archive/178345

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

Article ID: 178345

Article Last Modified on 10/3/2003

-

APPLIES TO


 * 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 . 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:


 * 1) Create temporary databases of any size to use the dbids from the primary server.
 * 2) Create the new databases.
 * 3) Drop the temporary databases.

Additional query words: stproc st proc

Keywords: kbprb KB178345

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.