Force Service in a Database Mirroring Session (Transact-SQL)

To force service in a database mirroring session

1. Connect to the mirror server.
   
2. Issue the following statement:
   
   ALTER DATABASE <database_name> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS
   where <database_name> is the mirrored database.
   The mirror server immediately transitions to principal server, and mirroring is suspended.
   

Read More ->>