--恢复镜像 USE master; ALTER DATABASE dnt31 SET PARTNER RESUME --切换主备 USE master; ALTER DATABASE BLMS_WX SET PARTNER FAILOVER -----------暂停数据库镜像会话 ALTER DATABASE dnt31 SET PARTNER SUSPEND ------------------------删除数据库镜像 ALTER DATABASE dnt31 SET PARTNER OFF
原文：https://www.cnblogs.com/lonelyxmas/p/12701873.html