Help Center/ Relational Database Service_RDS for SQL Server/ Best Practices/ Restoring Data from Backup Files to RDS for SQL Server DB Instances
Updated on 2025-07-17 GMT+08:00

Restoring Data from Backup Files to RDS for SQL Server DB Instances

This section describes how to use automated or manual backup files to restore a DB instance to the status when the backup was created.

Best Practices

  • You can create a full backup file for your DB instance and use OBS and DRS to restore the backup file to an RDS for SQL Server DB instance.
  • The restoration must be from an earlier database version to the same or a later version. The version of local backups must be earlier than or the same as the version of the destination DB instance to be restored.

    For example, if the local database version is Microsoft SQL Server 2012 Standard Edition, you can only restore the local backups to Standard or Enterprise Edition of Microsoft SQL Server 2014 or 2016. You cannot restore the local backups to any versions of Microsoft SQL Server 2008 or Web Editions of Microsoft SQL Server 2014 and 2016.

  • For operation details on the RDS console, see Restoring a DB Instance to a Point in Time and Restoring a DB Instance from a Backup.