ApsaraDB RDS for SQL Server supports restoring one or more databases from a backup — either to a specific point in time or from a backup set. You don't have to restore the entire instance; you can select individual databases to restore.
Restore methods
| Method | Description | Use when |
|---|---|---|
| Point-in-time restore | Restores databases to any point within the backup retention period | You need to recover data up to a specific timestamp, such as just before an accidental deletion |
| Backup set restore | Restores databases from a complete backup snapshot | You want a clean rollback to a known-good state |
Scope of restore
For both methods, you can choose to restore:
All databases on the instance — restores the entire instance to the selected point in time or backup set
Selected databases only — restores one or more individual databases without affecting others on the instance
Restore an individual database
For step-by-step instructions, see Restore the data of an ApsaraDB RDS for SQL Server instance.
该文章对您有帮助吗？