How to Resume a SQL Server Database Mirroring Session

Transact-SQL:
To resume a suspended SQL Server database mirroring session using T-SQL, run this code from either database mirroring partner:

database_resume_suspended_mirroring

ALTER DATABASE [Database_Name] SET PARTNER RESUME

This will resume paused database mirroring and place the mirror database from SUSPENDED to the SYNCHRONIZING state (and finally in SYNCHRONIZED state if the safety level is FULL and the mirror catches up with the principal):

database_resumed_suspended_mirroring

SQL Server Management Studio:
To resume a SUSPENDED SQL Server database mirroring session from SQL Server Management Studio:

Connect to the principal server instance -> Right-click the database -> select Tasks -> click Mirror:

database_tasks_mirror_resume

Click ‘Resume’:

database_resume_mirroring_ssms