sp_fallback_activate_svr_db (version 6.5)

Activates fallback support for the specified fallback enrolled databases for a primary server.

Syntax

sp_fallback_activate_svr_db [PrimarySvrName] [, DBNamePattern]

where

PrimarySvrName
Specifies the name of the primary server for which the local fallback server should provide fallback support. Executing this procedure without a PrimarySvrName (the default) indicates that there is one primary server with databases enrolled and to use the implied primary server name.
DBNamePattern
Specifies the name pattern of a database for which to activate the fallback support. The default is '%'. This parameter can be any pattern appropriate for the LIKE operator.

For more information about the LIKE operator, see Wildcard Characters in the Microsoft SQL Server Transact-SQL Reference.

Remarks

A database can be enrolled on its primary server and on its fallback support server for the same primary server. In the case where the primary server acts as both a primary server and fallback support server this enrollment strategy can be useful for load balancing schemes.

This procedure should be executed on the fallback server. If the hardware fallback changes are in place, then the activated databases is available approximately two seconds after this procedure is executed.

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.

Tables Used

master.dbo.spt_fallback_usg

See Also

sp_addremotelogin sp_helplogins
sp_addserver sp_serveroption
sp_change_users_login