Deactivates fallback support for the specified activated databases on a primary server. Deactivation leaves the databases enrolled.
sp_fallback_deactivate_svr_db [PrimarySvrName]
[, DBName Pattern]
where
For more information about the LIKE operator, see Wildcard Characters in the Microsoft SQL Server Transact-SQL Reference.
This procedure should be executed on the fallback server.
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 |