Database File movement in SQL AlwaysOn Availability group: A walk-through

Hello all,   In this blog, we are covering the scenario of moving the database files of AlwaysOn Availability Group (AG) enabled database to another location on all replicas with minimum downtime. To demonstrate database file movement, using Windows 2012 R2 cluster with AlwaysOn configured on SQL 2016 instance. This walk-through provides an example of…

2

Migrating database from AlwaysOn AG to another with JoinOnly option

Hi all,  In this blog, I am covering a scenario of migrating a SQL database from one AlwaysOn Availability Group (AG) to a new AG. I was involved in such requirement and the goal was to migrate the database which was in terabytes size to another AG without having to apply the Full back up…

0

SSIS package execution failure when SSISDB is configured with AlwaysOn

Hello all, Recently I worked on an interesting issue with SSIS package execution issue. In this blog, I am sharing the steps taken to isolate the cause and fix it. Issue Description: SSIS Package execution fails when it is executed from Integration Services catalog from the secondary replica node using the listener name. No issue…

0