sql2016创建镜像数据库时报错(Microsoft SQL Server, Error: 927)

在配置镜像最后一步报错：Database ‘XXX’ cannot be opened. It is in the middle of a restore. (Microsoft SQL Server, Error: 927)

解决办法：
执行命令
镜像库Mirror Server:

USE MASTER; GO ALTER DATABASE SET PARTNER = ‘TCP://PrincipalServer:5022’ GO

主库Principal server:

USE MASTER; GO ALTER DATABASE SET PARTNER = ‘TCP://MirrorServer:5022’ GO