Establishes the local fallback support server as the sole owner of the active databases for an obsolete primary server.
sp_fallback_permanent_svr {'PrimarySvrName,' 1}
where
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.
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
Only the system administrator can execute this procedure on the local primary server.
master.dbo.spt_fallback_usg
sp_addremotelogin | sp_helplogins |
sp_addserver | sp_serveroption |
sp_change_users_login |