具有数据库SQL镜像的Project Server 2010故障转移环境 [英] Project Server 2010 failover environment with Database SQL Mirroring

问题描述

 

你好，

 

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 setup all your SharePoint  and project databases to 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.

干杯！

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