SQL Server 2016 _无法启动镜像 [英] SQL Server 2016 _can't start mirror

问题描述

将SQL Server 2014升级到SQL Server 2016(两个企业版)后，我无法启动镜像.

After upgrading SQL Server 2014 to SQL Server 2016 (both Enterprise editions), I can't start mirror.

这在SQL Server 2014上正常工作.

This works normally on SQL Server 2014.

在使用主数据库的完整备份和日志备份还原(WITH NORECOVERY)镜像数据库之后，我通常会运行configure setup.

After I restore (WITH NORECOVERY) mirror database with full and log backups of primary database I normally run configure setup.

点击Start mirror后，出现此错误:

数据库'DatabaseName'无法打开.它在还原过程中. (Microsoft SQL Server，错误:927)

Database 'DatabaseName' cannot be open. It is in the middle of a restore. (Microsoft SQL Server, Error:927)

推荐答案

SQL 2016 GUI问题.它与TSQL命令配合使用.

Issue with SQL 2016 GUI. Its worked with TSQL commands.

使用大师； 去 ALTER DATABASE SET PARTNER ='TCP://PrincipalServer:5022' 开始

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

使用主控；

ALTER DATABASE SET PARTNER ='TCP://MirrorServer:5022' 开始

ALTER DATABASE SET PARTNER = 'TCP://MirrorServer:5022' GO

在执行这些命令之前，您应该在DR上具有完全备份"和日志备份"还原，并且无法恢复.

before executing these commands, you should have Full and log backup restore on DR with no recovery.

这篇关于SQL Server 2016 _无法启动镜像的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！