SQL Server 2012的数据库镜像 [英] database mirroring for SQL server 2012

问题描述

我已在每个名称DB1&上设置了2台带有SQL Server 2012的服务器。 DB2。

I have set up 2 server with SQL server 2012 on each name DB1 & DB2.

我用事务日志备份了DB1的实例并将其恢复到DB2。

I have backup the instance of DB1 with the transaction log and restore it onto DB2.

然后我右键单击DB1实例任务和镜像。

Then i right click on the DB1 instance on task and mirror.

"我在配置数据库镜像安全向导，镜像服务器实例： 

"I am in the Configure Database Mirroring Security Wizard, Mirror server instance: 

我得到他的校长和镜子 服务器实例不能是SQL服务器的同一实例./

I get his Principal and mirror  server instances cannot be the same instance of SQL server./

选择另一个实例作为镜像服务器实例。"

Select another instance as the mirror server instance."

请告知如何解决上述信息。

Please advise how to resolve the above message.

推荐答案

您已连接到镜像的同一实例。就像你在db2的Inst1上有DB1一样，你需要连接到inst2，它似乎已连接到Inst1。请检查。 DB2驻留在哪里，是否驻留在Inst1或其他一些inst2上？

You have connected to same instance for mirror. Like you have DB1 on Inst1 for db2 you need to connect to inst2 and it seems you have connected to Inst1. Please check. Where does DB2 resides, does is resides on Inst1 or some other inst2 ?

这篇关于SQL Server 2012的数据库镜像的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！