CommanderBond

Results 3 comments of CommanderBond

+1 from me for this issue. We are currently deploying Distributed Availability Groups and hence transaction log backup jobs fail in secondary DC and so will differential backup jobs tonight.

Yes, this happens since IndexOptimize is typically in another database than the objects to be stats-updated. If it touches in-memory objects there, it won't work because more than one database...

This has nothing to do with Ola's awesome maintenance solution. The issue you are describing is typical for large index rebuilds in an AG environment. It doesn't matter if you...