Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

AG backups. skip database part of same AG doesn't work. #788

Open
logicinside22 opened this issue Dec 22, 2023 · 1 comment
Open

AG backups. skip database part of same AG doesn't work. #788

logicinside22 opened this issue Dec 22, 2023 · 1 comment

Comments

@logicinside22
Copy link

Description of the issue
Script by default backups all database in AG But when need to skip the backup which are in same AG it doesn't work.
I have AG name AG1 and db1,db2,db3,db4,db5 are part of AG1. If I want to skip the db3 & db5 from AG1 Backup it doesn't work.

SQL Server version and edition
Execute SELECT @@VERSION

Version of the script
Check the header of the stored procedure
Jan 2022 version.

What command are you executing?
EXECUTE dbo.DatabaseBackup
@AvailabilityGroups ='AG1, -db3, -db5'

What output are you getting?
Script still backup all Databases part of AG1 including db3 & db5.

@olahallengren
Copy link
Owner

At the moment it is not possible to exclude databases from an availability group. It is a good idea though. :-)

This is a general limitation, that is not specific to EMC Data Domain.

@olahallengren olahallengren changed the title EMC data Domain: AG backups. skip database part of same AG doesn't work. AG backups. skip database part of same AG doesn't work. Nov 2, 2024
# for free to join this conversation on GitHub. Already have an account? # to comment
Projects
None yet
Development

No branches or pull requests

2 participants