SQLServer replication and database mirroring detailed configuration deployment

SQLServer replication and database mirroring detailed configuration deployment

Https://blog.csdn.net/kk185800961/article/details/46369577

SQL Server Literacy Series-Mirror articles

Https://blog.csdn.net/dba_huangzj/article/details/35995083 ALTER DATABASE (Transact-SQL) Database Mirroring

Https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-database-mirroring?view=sql-server-2017

USE [master]

95.GO

96.muri-subject execution: set to high security mode (synchronous)

97.ALTER DATABASE [MyDB] SET SAFETY FULL

ninety-eight。

99.Murray-body execution: set to high performance mode (asynchronous)

100.ALTER DATABASE [MyDB] SET SAFETY OFF

one hundred and one。

102. Color-subject execution: switching between principal and mirror

103.ALTER DATABASE [MyDB] SET PARTNER FAILOVER

one hundred and four。

one hundred and five。

106.ALTER DATABASE [MyDB] SET PARTNER RESUME;-restore the mirror

107.ALTER DATABASE [MyDB] SET PARTNER FAILOVER;-- switch between master and slave

108.ALTER DATABASE [MyDB] SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS;-Force restore of the mirror

109.ALTER DATABASE [MyDB] SET ONLINE;-- online database

one hundred and ten。

one hundred and eleven。

112.select * from sys.certificates

113.select * from sys.endpoints

114.select * from sys.database_mirroring_endpoints

115.select * from sys.database_mirroring

116.select * from sys.database_mirroring_witnesses