SQLServer 復(fù)制和數(shù)據(jù)庫鏡像 詳細(xì)配置部署

SQLServer 復(fù)制和數(shù)據(jù)庫鏡像 詳細(xì)配置部署

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

 SQL Server掃盲系列——鏡像篇

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.--主體執(zhí)行:設(shè)置為高安全模式（同步） 
97.ALTER DATABASE [MyDB] SET SAFETY FULL   
98. 
99.--主體執(zhí)行:設(shè)置為高性能模式（異步） 
100.ALTER DATABASE [MyDB] SET SAFETY OFF   
101. 
102.--主體執(zhí)行:主體與鏡像切換 
103.ALTER DATABASE [MyDB] SET PARTNER FAILOVER;   
104. 
105. 
106.ALTER DATABASE [MyDB] SET PARTNER RESUME;     --恢復(fù)鏡像   
107.ALTER DATABASE [MyDB] SET PARTNER FAILOVER;   --切換主備   
108.ALTER DATABASE [MyDB] SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS;  --強(qiáng)制恢復(fù)鏡像   
109.ALTER DATABASE [MyDB] SET ONLINE;     --在線數(shù)據(jù)庫   
110. 
111. 
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