How to Stop and Start Database Mirroring Endpoints in SQL Server - MS SQL SQL DBA Tutorial

In this video you will learn how to Stop and Start Mirroring endpoints in SQL Server, it shows step by step resolution to mirroring issue " Database stuck in recovery state in Mirroring" It illustrates how to check the status of Mirroring, how to stop Mirroring endpoint using T-SQL Script, checking status of mirroring after stopping the endpoints, how to start the Mirroring endpoints and checking the status of Mirroring after starting Mirroring endpoints.

Script to Stop or Start Database Mirroring EndPoints in SQL Server
ALTER ENDPOINT Mirroring STATE=STOPPED
go
ALTER ENDPOINT Mirroring STATE=STARTED

Stop and Start Database Mirroring Endpoints in SQL Server

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.