Deleted RDS Database and Snapshot

If you've deleted an RDS database and its snapshot appears to be missing from your console view, there are several steps you can take:

1. Check different AWS regions in the RDS console. Your snapshot might exist in a different region than the one you're currently viewing.

2. Verify that you're looking in the correct section of the RDS console. Navigate to the "Snapshots" section in the navigation pane to see all available snapshots.

3. If the AWS support agent can see the snapshot but you cannot, this could be due to:

• Permission differences between your IAM user/role and the support agent's access
• The support agent might be looking at a final snapshot that was automatically created during deletion

4. For SQL Server instances, Amazon RDS often creates a final snapshot when a database is terminated. These snapshots are typically named in the format instance_name-final-snapshot.

5. To restore from a snapshot that the support agent can see but you cannot:

• Ask the support agent to share the exact snapshot identifier
• Request that they verify your IAM permissions are sufficient to view and restore the snapshot
• They may need to help you restore the snapshot using their access

6. Once you locate the snapshot, you can restore it by:

• Selecting the snapshot in the RDS console
• Choosing "Restore Snapshot" from the Actions menu
• Providing a new DB instance identifier
• Completing the restoration process

If you still cannot access the snapshot, continue working with AWS Support as they may be able to assist with the restoration process directly or help adjust your permissions to access the snapshot.
Sources
Restor RDS from Snapshot, no data | AWS re:Post
Restoring from an RDS Custom for SQL Server DB snapshot - Amazon Relational Database Service
Restoring license-terminated DB instances for Amazon RDS for SQL Server - Amazon Relational Database Service