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

If the post helped you, please share it:
Pin It

1 comment to How to Resume a SQL Server Database Mirroring Session

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">