在同一SQL服务器上进行SQL数据库镜像 [英] Sql database mirroring on same SQL server

问题描述

是否可以在同一个sql server上镜像数据库？

如果是，那么请提供给我步骤对于它。



谢谢



我的尝试：



我在网上搜索这个，但似乎这是不可能的。需要对此进行确认。

Hi,

Is it possible to mirror the database on the same sql server?
If yes then please provide me the steps for it.

Thanks

What I have tried:

I am searching for this online but it seems this is not possible. Need a confirmation for this.

推荐答案

可能但你必须通过箍来实现它。这也绝对没有意义。镜像的整个要点是在发生故障转移时保持可用性......这将是服务器失败，因此您将丢失生产和故障转移SQL Server实例。



还要注意

It is possible but you have to jump through hoops to achieve it. It is also absolutely pointless. The whole point of mirroring is to maintain availability in the event of a failover ... it's going to be the server that fails so you will lose both your production and failover SQL Server instances.

Also be aware

Quote：

此功能将在未来版本的Microsoft SQL Server中删除。避免在新的开发工作中使用此功能，并计划修改当前使用此功能的应用程序。请改为使用Always On Availability Groups。

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use Always On Availability Groups instead.

并注意数据库镜像的先决条件，限制和建议| Microsoft Docs [ ^ ]



如果你坚持继续使用mirrowing，那么本文给出了步骤：镜像SQL Server数据库并不困难如你所愿 [ ^ ]

and be aware of Prerequisites, Restrictions, and Recommendations for Database Mirroring | Microsoft Docs[^]

If you insist on going ahead with mirrowing then the steps are given in this article: Mirroring a SQL Server Database is not as hard as you think[^]

这篇关于在同一SQL服务器上进行SQL数据库镜像的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！