Follow-up Steps

Additional fallback-related system stored procedures are listed below.

On primary server svrprimary:

1. To list the name of the fallback servers for this primary server, execute:

   exec sp_helpserver
     

2. If svrfallback has already been added as an RPC or replication server, then execute:

   exec sp_serveroption 'svrfallback', 'fallback', true
     

3. Invoke the following stored procedure when the primary server is fixed and is ready to take over the disk from the fallback server. This leaves the enrollment of the databases of the primary server intact on the fallback server.

   exec sp_fallback_deactivate_svr_db 'svrprimary', '%'
     

4. Invoke the following stored procedure on the fallback server to make the fallback SQL Server server the permanent owner of databases enrolled from another SQL server:

   exec sp_fallback_permanent_svr 'svrprimary' ,1
     

5. On the fallback server svrfallback, produce a report of enrollment and activation statuses, and perform integrity checks:

   exec sp_fallback_help
     

On the fallback server SVRFALLBACK:

• Invoke the following stored procedure on the fallback server to remove the enrollment of a specific database from the fallback database server:

  exec sp_fallback_withdraw_svr_db 'svrprimary' ,'DabProduct'