sp_fallback_withdraw_svr_db (version 6.5)

Erases the enrollment of inactive databases for a primary server.

Syntax

sp_fallback_withdraw_svr_db {'PrimarySvrName' [, DBNamePattern]}

where

PrimarySvrName

Specifies the name of a primary server that contains inactive enrolled databases.

DBNamePattern

Specifies the name pattern for enrolled databases. 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 must be executed on the fallback support server by using a direct connection to the fallback support server, or by using a remote stored procedure call to the fallback support server while connected to the primary server.

When executing this procedure for troubleshooting problems with fallback support, supply only PrimarySvrName so DBNamePattern defaults to '%' for all enrolled databases on a primary server.

Permission

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

Tables Used

master.dbo.spt_fallback_usg

See Also