PRB: Moving Fallback DB Back to Primary Svr May Cause Error 913

• Microsoft SQL Server, version 6.5

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:

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.