Snippet Name: Check_native_backup_enablement

Tags:

Created Date: 2025-06-16 13:12:42
Last Modified Date: 2025-05-31 10:32:05

Dependencies:

DBA Notes:

Sample Output:

Title: Check native backup enablement
Author: user
[File]: file-74fBMGXqYk8o27Nd3YXJei-image.png

Author: ChatGPT
To check if the **native backup and restore option** is enabled on your **AWS RDS SQL Server instance**, follow these steps:

### 1. **Check Using AWS Management Console**
1. Sign in to the **AWS Management Console**.
2. Navigate to **Amazon RDS**.
3. Select your **SQL Server RDS instance**.
4. Go to the **Configuration** tab.
5. Under **DB options**, look for `rds_backup_restore` in the **Option Group** section.

   - If `rds_backup_restore` is listed, the native backup and restore feature is **enabled**.
   - If it's not listed, it's **not enabled**, and you may need to add it.

---

### 2. **Check Using AWS CLI**
Run the following AWS CLI command:

```sh
aws rds describe-option-group-options --engine-name sqlserver-ee
```

Replace `sqlserver-ee` with the correct edition:
- `sqlserver-ee` (Enterprise Edition)
- `sqlserver-se` (Standard Edition)
- `sqlserver-ex` (Express Edition)
- `sqlserver-web` (Web Edition)

If `rds_backup_restore` appears in the output, it means your SQL Server supports it.

---

### 3. **Check Using T-SQL**
You can also check directly from SQL Server by running:

```sql
SELECT * FROM msdb.dbo.rds_fn_backup_db;
```

If the function executes successfully, **native backup and restore is enabled**.

---

### 4. **Enable Native Backup and Restore (If Needed)**
If `rds_backup_restore` is not enabled, you can enable it by modifying the **option group**:

```sh
aws rds modify-option-group \
    --option-group-name my-option-group \
    --options "OptionName=rds_backup_restore"
```

Replace `my-option-group` with your actual option group name.

Let me know if you need further help!