Question : When creating new maintenance jobs for an alwayson setup with new service accounts, should we ensure that the […]
Tag: availability-groups
File share Witness or Disk Witness
Question : I have 2 SQL Servers at production site Windows Server Failover Cluster and 1 SQL Server at DR […]
SQL SERVER 2014 Standard – High Availability Listener solution
Question : The company has SQL Server 2014 Standard licenses and we’re standing the servers up in a VMware environment. […]
Availability groups NIC best practices
Question : I am planning to build a new AG setup in my QA environment with the following configuration. What […]
SQL Server 2017 AlwaysOn Failover Cluster issue
Question : I have 2 Windows 2012R2 VM’s running on Vmware ESXi 7 with VMDK’s as the SQL disks. I […]
Change Data Capture for Asynchronous Secondary Replica
Question : MSDN states the following in Active Secondaries: Readable Secondary Replicas (AlwaysOn Availability Groups) for SQL Server 2014: Limitations […]
Always On – Restore a node from a Veeam backup
Question : I have a cluster with 2 nodes, and Veeam is backing up databases every day and logs every […]
Create Linked Server to AlwaysOn Availability Group Listener
Question : I have an alwayson availability group setup using SQL 2014 and Windows Server 2012 R2. There are 3 […]
SQL Server secondary replica snapshot with Basic Availability Group
Question : I have the following scenario: I created an HA group of two nodes in SQL Server 2016 Standard […]
Configure unconstrained delegation for BULK INSERT
Question : I have a pair of Microsoft SQL Server 2016 nodes in an Always On Availability Group. I am […]