sp_fallback_enroll_svr_db (version 6.5)

Enrolls a primary server's database into the staging tables of a fallback server, which prepares the server for future fallback support activation.

Syntax

sp_fallback_enroll_svr_db {PrimarySvrName, DBName}

where

PrimarySvrName

Specifies the name of the server that is ready to provide fallback support. If no value is specified, the implied value is the fallback server that is defined on the primary server.

DBName

Specifies the name of a database to enroll in fallback support. This database will be enrolled on the remote fallback server and must be owned by the local or primary server.

Remarks

This procedure should be run locally on the fallback server. The primary server must already be locally defined on the fallback server.

When a server enrolls its own active database and uses itself as the fallback server, the enrolled database is immediately recorded as being actively supported in the spt_fallback tables. In this case, the primary server acts as its own fallback support server. This enrollment strategy can be useful for activating or deactivating a database on the primary server.

For more information about fallback support, see Fallback Support in "What's New for Administrators," earlier in this document.

Permission

Only the system administrator can execute this procedure on the local primary server.

Tables Used

master.dbo.spt_fallback_usg

See Also