TechBrothersIT is the blog spot and a video (Youtube) Channel to learn and share Information, scenarios, real time examples about SQL Server, Transact-SQL (TSQL), SQL Server Database Administration (SQL DBA), Business Intelligence (BI), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Warehouse (DWH) Concepts, Microsoft Dynamics AX, Microsoft Dynamics Lifecycle Services and all other different Microsoft Technologies.
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
goALTER ENDPOINT Mirroring STATE=STARTED
Stop and Start Database Mirroring Endpoints in SQL Server