Activates fallback support for the specified fallback enrolled databases for a primary server.
sp_fallback_activate_svr_db [PrimarySvrName] [, DBNamePattern]
where
For more information about the LIKE operator, see Wildcard Characters in the Microsoft SQL Server Transact-SQL Reference.
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.
Only the system administrator can execute this procedure.
master.dbo.spt_fallback_usg
sp_addremotelogin | sp_helplogins |
sp_addserver | sp_serveroption |
sp_change_users_login |