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

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

*********************************************************************************************
How to Stop and Start Database Mirroring Endpoints in SQL Server
***********************************************************************************************
* Using T-SQL
Learnings:
1- Status of Database Mirroring
2- How to Stop Mirroring EndPoint
3- Mirroring Status after Stopping Mirroring
4- How to Start Mirroring EndPoint
5- Status After EndPoint Start

--Script--
ALTER ENDPOINT Mirroring STATE=STOPPED
GO
ALTER ENDPOINT Mirroring STATE=STARTED
GO

Note: Follow the process shown in the video.
😉Subscribe and like for more videos:
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment

Tutorial Link:

Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
_____________________________________________________________________
Note: All scripts used in this demo will be available in our website.
Link will be available in description.

#sqlserver
#sqlserverlogshipping
#sqlserverlogshippingremove
#sqlservermanagementstudio
#sql_server
#databasemirroring
#sqlmirroring
#sqlservermirroring
#dbmirroring
#sqlservertutorial
#chiragstutorial
#databasetutorial
#sqlqueries
#sqldba
#database
#databasemanagement
#chiragstutorial
#chirags
#createdatabaseinmysql
#DBATutorial
#DBATutorialLearning
#DBAEducation
#DBATutorialFree
#DatabaseTutorial
#SQLServerDatabaseTutorial
#SQLServerDBATutorial
#MicrosoftSQLServerDatabaseTutorial
#ChiragsDBATutorial
#ChiragsDatabaseTutorial
#ChiragsSQLServerDatabaseTutorial
#ChiragsSQLServerDBATutorial
#ChiragsMicrosoftSQLServerDatabaseTutorial
#CreateDatabaseinSQLServer
#CreateDatabasewithT-SQL