Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

AWS Backup, VSS, SQL Server and the CopyOnly Parameter

0

Greetings! Trying to implement AWS Backup and have several SQL Server EC2 instances where I want to use VSS backups with the CopyOnly parameter so that the differential backup chain is not broken. AWS Backup has a Windows VSS option in "Advanced backup settings", but I can't seem to find the CopyOnly parameter. I see the param in the AWSEC2-CreateVssSnapshot document. Curious what I'm missing in AWS Backup? Suggestions and links to doc much appreciated (console and/or CDK if available).

Many Thanks! Bryan

Topics
Storage
Tags
AWS Backup
Language
English
asked 2 years ago600 views
4 Answers
0
Accepted Answer

Okay. If there were features available for use but just not visible in the console, they would show in the API documentation. For AWS Backup, the CreateBackupPlan API (https://docs.aws.amazon.com/aws-backup/latest/devguide/API_CreateBackupPlan.html) accepts the AdvancedBackupSettings property (https://docs.aws.amazon.com/aws-backup/latest/devguide/API_AdvancedBackupSetting.html). It doesn't allow for configurability beyond VSS being enabled or not.

EXPERT
answered 2 years ago
EXPERT
reviewed a year ago
0

A copy-only backup is launched by providing the COPY_ONLY option to the BACKUP DATABASE statement in SQL Server used to start the backup. I don't think it should affect the integration between SQL Server and VSS in any way, so I don't think there's any VSS configuration to change for it to work.

EXPERT
answered 2 years ago
0

https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/create-vss-snapshots-ssm.html

CopyOnly (string, optional) If you use the native SQL Server backup in addition to AWS VSS, performing a Copy-only backup prevents AWS VSS from breaking the native differential backup chain. To perform a Copy-only backup operation, set this parameter to True. The default value for this parameter is False, which causes AWS VSS to perform a full backup operation.

In an old home-grown backup solution using SSM documents, Lambda and Step Functions, the value was being set to avoid resetting the backup chain of the native SQL Sever backups that are also being performed in addition to the snapshot backups.

I'm trying to find the same parameter in AWS Backup that exists in the SSM AWSEC2-CreateVssSnapshot document.

Thx! Bryan

answered 2 years ago
0

Thanks, Leo.

I confirmed through support there was nothing available. It's now officially a feature request.

Cheers! Bryan

answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content