具有数据库SQL镜像的Project Server 2010故障转移环境

本文介绍了具有数据库SQL镜像的Project Server 2010故障转移环境的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

你好，

Hello,

我们有生产和故障转移的环境。通过使用服务器场备份和恢复prod创建的故障转移环境。

We have prod and failover environment. Failover environment created by using farm backup and restore of prod.

我的问题是：我们可以进行5个数据库的SQL镜像（从prod到故障转移）（4 PS数据库和内容db）以保持环境同步。这个过程是否适用于Project Server 2010.由于配置数据库中的时间戳和GUID，我有疑问。

my question is : Can we do SQL Mirroring (from prod to failover) of 5 databases (4 PS databases and content db) to keep both the environment in sync. Will this process work in the case of Project Server 2010. i am in doubt due to timestamp and GUID in config DB.

此过程也将是支持的。

Also will this process is supportable.

任何帮助都非常感谢。

Any help much appreciated.

谢谢

Thanks

推荐答案

Hello MOhit2020，

Hello MOhit2020,

我没有做过这种类型的故障转移，但我认为您需要设置所有的SharePoint和项目数据库使用SQL别名指向生产数据库。当您的生产数据库失败时，您将更新您的SQL别名以指向镜像位置。

I haven't done this type of failover, but I think you would need to setupall your SharePoint and project databasesto use a SQL Alias to point to your production databases. When and if your production databases failed, you would update your SQL Alias to point to the mirror location.

在SharePoint中设置SQL别名的另一个不错的功能是在将来，如果你切换到另一个SQL Server，SQL别名会使它更容易处理。

The other nice feature about having SQL Alias setup in SharePoint, is that in the future, if you switch to another SQL Server, the SQL alias makes it easier to handle.

干杯！