Skip to content
New issue

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

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

Already on GitHub? Sign in 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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants