I would like to take a baily backup with 7 days retention period for SQL Server DB which installed on Amazon Linux EC2 instance.
I tried the below two scenarios with no luck:
- -RetentionDays
- The below script:
EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure 'media retention', 1;
GO
RECONFIGURE;
GO