search

olahallengren / sql-server-maintenance-solution

SQL Server Maintenance Solution
https://ola.hallengren.com
MIT License
2.91k stars 756 forks source link

Treat Distribtion Db in AG as a User Db #713

Open DSQLJazzman opened 1 year ago

DSQLJazzman commented 1 year ago

Description of the feature It can be a new feature, or a change to an existing feature Hello Ola, I appreciate that you have to script the Distribution database to add it to AG & there are considerations to doing it. We have recently done just that to make our replication more resilent, when I spotted a sort of issue. When the Distributor is in an AG, I would like it to backup it's T-Logs the same way as I do other AGs. To do this I had to set the @Databases parameter to ALL_DATABASES from the standard USER_DATABASES. Is it possible to treat Distribution like user database, when they are in an AG​ for Backup, etc I suspect that there are not too many folks looking to put the Distributor in to AG,​ but I thought I would raise as thought for a feature enhancement in a future release. Thank you for all you do for the community

Richard Gilbert

olahallengren commented 2 weeks ago

Another option could be to create a log backup job for the Distribution database.