Achieve point-in-time recovery for all databases in Amazon RDS Custom for SQL Server

This article discusses how to achieve point-in-time recovery for all databases in Amazon RDS Custom for SQL Server, even for those that are not eligible for the managed point-in-time recovery feature due to instance type limitations.

Specifically, the article covers:

• Creating and populating the msdb.dbo.rds_pitr_blocked_databases table to specify databases to exclude from managed point-in-time recovery
• Solution 1: Backing up and restoring excluded databases to and from an Amazon FSx file share
• Solution 2: Backing up and restoring excluded databases to and from Amazon S3 (for SQL Server 2022 or later)
• Steps to restore all databases (managed and unmanaged) to a specific point in time
• Best practices for managing storage costs and persistence in Active Directory
• Clean-up steps to delete resources and avoid incurring costs