> For the complete documentation index, see [llms.txt](https://docs.opsmx.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.opsmx.com/opsmx-1/opsmx-context-engine/additional-resources/database/periodic-backup-and-recovery-of-isd-db.md).

# Periodic Backup and Recovery of ISD DB

### To do periodic backup configuration in AWS

1. Create RDS in the AWS cloud with DB. 
2. During database creation the backup retention period should be configured. Select the days from the dropdown as shown below. The days can be between 7 to 35.

<figure><img src="https://lh5.googleusercontent.com/9-hTuz6ppbPekgQId0JXvDbfljVHt27XpLuqktZVL0zqByfzrF8CUY_s9mb926fWN7BAYjphTnLWNmEKdKg6kV9iR5RUFiLlg-XfHJjlKdsnxZxtseulkfYW-eNzo_cOcqo97wKO40678vpyOqmPVHM" alt="" width="563"><figcaption></figcaption></figure>

3. The created DB is displayed as shown.

<figure><img src="https://lh5.googleusercontent.com/C7Jz-BrxMmz4MvJqoAVSVkhfqLLJS8BibTVgANa3T5F-9kGZJSAveGSIQ__1KA-_3poCKWqknRiFcw7wpclW-JhKZvuDuCxuwUpwnBaiT9_VgUziUlZqxssQ4jZDyk4sZ7WcZzJveAZLQbETHKRN6Qg" alt="" width="563"><figcaption></figcaption></figure>

4. It contains the End point to connect to ISD.
5. External isd db can be configured in the services like:
   * oes-autopilot
   * oes-platform
   * oes-sapor
   * oes-datascience
   * oes-visibility
   * oes-audit
6. External DB configuration during installation with helm chart

```
  db:
  enabled: true
  url: jdbc:postgresql://database-1.cluster-cyjw4hmntwfy.us-east-1.rds.amazonaws.com:5432
  username: postgres
  password: encrypted:dbpassword:dbpassword
```

### Enabling automated backups to existing DB

1. Sign into the AWS Management Console and open the Amazon RDS console.
2. In the Navigation pane, choose Databases, and then the DB instance or Multi-AZ DB cluster that you want to modify.
3. Choose Modify.
4. For Backup retention period, choose a positive nonzero value, for example 3 days.
5. Choose Continue > Apply immediately.
6. Choose Modify DB instance or Modify cluster to save your changes and enable automated backups.

### Export backups to S3 bucket for longer period backup&#x20;

1. Sign into the AWS Management Console and open the Amazon RDS console.
2. In the Navigation pane, choose Snapshots.
3. From the tabs, choose the type of snapshot that you want to export.
4. In the list of snapshots, select the snapshot that you want to export.
5. For Actions, choose Export to Amazon S3.
6. For Export identifier, enter a name to identify the export task. This value is also used for the name of the file created in the S3 bucket.
7. Choose the data to be exported:
8. Choose All to export all data in the snapshot.
9. Choose the bucket to export to.
10. For IAM role, either choose a role that grants you write access to your chosen S3 bucket, or create a new role.
11. For AWS KMS key, enter the ARN for the key to use for encrypting the exported data.
12. Choose Export to Amazon S3.&#x20;

### Restore backup configuration in AWS

#### Restore a DB instance from a DB snapshot

1. Sign in to the AWS Management Console and open the Amazon RDS console
2. In the Navigation pane, choose Snapshots.
3. Choose the DB snapshot that you want to restore from.
4. For Actions, choose Restore snapshot.
5. On the Restore snapshot page, for DB instance identifier, enter the name for your restored DB instance.
6. Specify other settings, such as allocated storage size.\
   For information about each setting, see[ Settings for DB instances](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CreateDBInstance.html#USER_CreateDBInstance.Settings).
7. Choose Restore DB instance.

<figure><img src="https://lh3.googleusercontent.com/SotV5un_RHOGo7Dlg31IQtsaX_iZjZIRVTUBTW9-cBBYQf852u1CjMn2Rlh0iOivYV6qyhOP8r1-OozMkxFYFcEBh5pJM7pfkwpX-G251nLHtzQ8NjvE-AM8VVh6_bu4HrMEYlroE0MuPi2rv7XCad4" alt="" width="563"><figcaption></figcaption></figure>

8. Once you click on the restore snapshot it will redirect to create a DB instance with snapshot.
9. After DB instance is created, get the configuration details and add to the ISD service.
10. External isd db can be configured in the services like
    * oes-autopilot
    * oes-platform
    * oes-sapor
    * oes-datascience
    * oes-visibility
    * oes-audit
11. External DB configuration during installation with helm chart

```
db:
enabled: true
url: jdbc:postgresql://database-1.cluster-cyjw4hmntwfy.us-east-1.rds.amazonaws.com:5432
username: postgres
password: encrypted:dbpassword:dbpassword
```

12. Once it is configured LOGIN to ISD and test the data.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.opsmx.com/opsmx-1/opsmx-context-engine/additional-resources/database/periodic-backup-and-recovery-of-isd-db.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.