RDS SQL Server database restore on Multi-AZ

Question

Hi,

We are planning to restore the databases on RDS SQL Server multi-AZ. it looks like we need to deploy the single-az before restoring the databases(full+diff+log) and modify it into multi-AZ once restoration is completed, Is it correct

Can we restore the full+diff+log on Multi-AZ directly as we need to take the downtime whenever we restore the databases on MULTI-AZ?

Answer

Hi ,

Native backup and restore is available in all AWS Regions for Single-AZ and Multi-AZ DB instances, including Multi-AZ DB instances with read replicas. Native backup and restore is available for all editions of Microsoft SQL Server supported on Amazon RDS.

However consider following limitations when using native backup and restore with multiAZ.

* On Multi-AZ DB instances, you can only natively restore databases that are backed up in the full recovery model.
* Restoring from differential backups on Multi-AZ instances isn't supported.

Review the further [limitations ](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html#SQLServer.Procedural.Importing.Native.Limitations)and more details about [using native backup and restore with RDS for SQL Server](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html).

Answer

Yes, you can to a point in time recovery directly to multi-az.

RDS SQL Server database restore on Multi-AZ

Relevant content