Backup on availability group level SQL Server

EricG

I've a question about setting up the backup job true Redgate SQL Backup pro 9. We currently use Redgate but we backup on database level. We use the settings from the site to get a nice and efficient setup.

Then point where I get stuck is that when we add a new database. I have to add it manualy via the job in SSMS time 2 because it is clustered. And then for Tlog and full. Or via redgate. What I would like if I could add the availability group into the job instead of the databases. Is there an option to do this via redgate or is it possible to change the job in SSMS and change the databases and make it the availability group whitout generating errors or screwingup the process of redgate?

Thanks!

Jessica R

Hi @EricG!

The options for working with AlwaysOn availability groups are listed here: https://documentation.red-gate.com/sbu9/backing-up/alwayson-availability-groups

Hope that helps!

EricG

Thanks, but we already have this in place. The issue what I'm facing is with adding new databases to an AG. now I have to manualy add the database to the backup. Just looking how I can connect the AG group instead of every single database.

Jessica R

Ah, there isn't an option for that at the moment, I'm really sorry to say. Could you please post a request for this on our uservoice forum here: https://sqlbackup.uservoice.com/forums/91737-sql-backup?

Thank you!