Backup on availability group level SQL Server

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!

EricG August 07, 2018 13:51

Comments

3 comments

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!

Jessica R August 08, 2018 23:55

0
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.

EricG August 09, 2018 07:43

0
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!

Jessica R August 13, 2018 16:47

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Backup on availability group level SQL Server

Comments

Add comment