Help Center/ Relational Database Service/ Best Practices/ RDS for SQL Server/ Restoring Data from Backup Files to RDS Microsoft SQL Server DB Instances
Updated on 2024-09-06 GMT+08:00
View PDF
Share

Restoring Data from Backup Files to RDS Microsoft 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 Microsoft 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.
Parent Topic: RDS for SQL Server