Tag Info

Advantages of Transactional Replication over Availability Groups for Reporting Workloads As a counter-point to the answer above, here are some reasons why transactional replication may be a better solution than availability groups for reporting workloads. You can replicate a subset of tables in the database. Availability Group Replicas are always the ...

Since you are talking about Availability Groups, there isn't an instance startup like you're thinking about as there is with failover cluster instances. Because all replicas/instances are online (during normal operation of course) you can't leverage the same implementation of running a "startup procedure". Off the top of my head, the way to do this would ...