Whitepaper on building an AlwaysOn HADR solution for DQS using Availability Groups

  • Article

A whitepaper is now available on building an AlwaysOn high-availability and disaster-recovery (HADR) solution for DQS using the Availability Groups feature in SQL Server 2012. You can download the whitepaper from here.

The unit of failover in an Availability Group is a group of user databases only. However, just failing over 3 DQS databases is not sufficient for the DQS application to be highly available. The Data Quality Server component in DQS requires other objects apart from the 3 DQS databases to be functional such as SQL Common Language Runtime (SQLCR) assemblies, the 2 DQS SQL Server logins, and the DQS initialization stored procedure in the master database on the target SQL Server instance.

You must perform some additional steps when configuring AlwaysOn Availability Groups for DQS to make it highly available. This white paper describes how you can work around the above issues to build a HADR solution for DQS.

Hope you find it useful.

Thanks,
Vivek
(SQL Server Documentation | Twitter: @vivek_msft)