sp_fallback_deactivate_svr_db (version 6.5)

Deactivates fallback support for the specified activated databases on a primary server. Deactivation leaves the databases enrolled.

Syntax

sp_fallback_deactivate_svr_db [PrimarySvrName]
[, DBName Pattern]

where

PrimarySvrName
Specifies the name of the primary server for which the local fallback server should stop active fallback support. Executing this procedure without a PrimarySvrName (the default) indicates 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

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.

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