sp_fallback_permanent_svr (version 6.5)

Establishes the local fallback support server as the sole owner of the active databases for an obsolete primary server.

Syntax

sp_fallback_permanent_svr {'PrimarySvrName,' 1}

where

PrimarySvrName
Specifies the name of an enrolled and active primary server in fallback support on the local fallback server.
1
Specifies an override. This parameter guards against an accidental execute of this procedure.

Remarks

This procedure should be run only on the fallback support server. This procedure deletes rows from spt_fallback tables. Formerly enrolled databases and databases originally stored on the local server can be distinguished only by drive letters stored in the sysdevices table in the phyname column.

Example

This example brings all active databases for the obsolete primary server MyPrimaryServer under the permanent control of the local fallback server.

sp_fallback_permanent_svr 'MyPrimaryServer', 1
  

Permission

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

Tables Used

master.dbo.spt_fallback_usg

See Also

sp_addremotelogin sp_helplogins
sp_addserver sp_serveroption
sp_change_users_login