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

2 comments:

  1. s for sharing the article, and more importantly, your personal experienceMindfully using our emotions as data about our inner state and knowing when it’s better to de-escalate by taking a time out are great tools. Appreciate you reading and sharing your story, since I can certainly relate and I think others can to
    https://shareit.onl/

    ReplyDelete
  2. and more importantly, your personal experienceMindfully using our emotions as data about our inner state and knowing when it’s better to de-escalate by taking a time out are great tools. Appreciate you reading and sharing your story, since I can certainly relate and I think others can too
    mxplayer.pro/

    ReplyDelete