0

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:

  1. -RetentionDays
  2. The below script: EXEC sp_configure 'show advanced options', 1;
    GO
    RECONFIGURE;
    GO
    EXEC sp_configure 'media retention', 1;
    GO
    RECONFIGURE;
    GO

0 Answers0