SQL Server AlwaysOn Configuration for Provisioning Services.

The purpose of this article is to explain the functionality of SQL Server AlwaysOn in relation to Citrix Provisioning Services PVS. The SQL Server AlwaysOn Availability Groups feature: Is a high-availability solution from Microsoft SQL - that provides an alternative to database mirroring...

AlwaysOn Availability Groups cannot be selected while restoring a SQL database to Microsoft SQL Server 2017 after installation of CU15

Challenge You try to restore a SQL database to Microsoft SQL Server 2017 with CU15 that supports AlwaysOn Availability Groups, but you are not able to select an availability group at the "Specify AlwaysON Restore Options" step. Cause ServerNetworkProtocolProperty is missing in CU15 for SQL Server...

Transaction Log Backup Job for Microsoft SQL Server with AlwaysOn Availability Groups fails after installing CU15 for SQL Server 2017

Challenge When utilizing Always On Availability Groups on a Windows Server Failover Cluster using Microsoft SQL Server 2017 and after installing Cumulative Update package 15 CU15 for SQL Server 2017, Veeam Transaction Log Backup Jobs may fail with the following error message in the the statistics...

VESQL database restore to Always On Availability Groups with automatic seeding enabled is hanging

Challenge VESQL database restore to Always ON Availability Group with automatic seeding enabled SQL 2016 SP1 and later does not work. Veeam SQL Explorer log shows repeating records like: 10/23/2017 8:19:22 PM 11 5160 SQL query: ALTER DATABASE SET HADR AVAILABILITY GROUP = 10/23/2017 8:19:32 PM 11...

Failed to prepare guest for SQL Server transaction log backup Details: Job owns SQL Server transaction logs backup

Challenge Microsoft SQL Server Log Backup job displays the following warning: Failed to prepare guest for SQL Server transaction log backup Details: Job owns SQL Server transaction logs backup This issue can also occur for Oracle Archived Log Backup, and will display the following warning: Cannot...