Back up a database
Data Management Service (DMS) lets you create scheduled backup plans for your databases, protecting against data loss caused by accidental deletion, corruption, or hardware failure. This topic explains how to create a backup plan in DMS.
Back up databases（English）.mp4
Prerequisites
Before you begin, make sure you have:
-
A database instance registered in DMS
-
The permissions required to create and manage backup plans in DMS
-
Sufficient storage quota for backup data
Backup types
DMS supports the following backup types:
| Backup type | Description |
|---|---|
| Full backup | A complete copy of the database |
| Incremental backup | Only the data changed since the last backup |
| Log backup | Transaction logs for point-in-time recovery |
Not all backup types are available for every database engine. Check your database engine documentation for supported backup types.
Create a backup plan
-
Log in to the DMS console.
-
In the left navigation pane, find and click the database instance you want to back up.
-
Navigate to the backup management section. The exact menu path depends on your DMS version:
-
For newer versions: click Data Security > Backup.
-
For older versions: click Operation & Maintenance > Backup.
-
-
Click Create Backup Plan.
-
Configure the backup plan:
Parameter Description Plan name A descriptive name for the backup plan Backup type Select the backup type (full, incremental, or log) Backup schedule Set the frequency and time for automatic backups Retention period How long to keep backup files before automatic deletion Storage location Where backup files are stored (default: Alibaba Cloud Object Storage Service) -
Click OK to create the backup plan.
After the plan is created, DMS runs the first backup according to the schedule you configured.
Verify backup status
To check whether a backup completed successfully:
-
Go to the backup management section for your database instance.
-
Click the backup plan name to view its history.
-
Confirm that the latest backup shows a Successful status.
Backups may not run if the database instance is in an unavailable state. If a scheduled backup is missed, check the instance status before investigating further.
Restore from a backup
To restore data from a backup, navigate to the backup history for your database instance, select the backup point you want to restore, and click Restore. For point-in-time recovery using log backups, specify the target time in the restore dialog.
For detailed restore instructions, see Restore a database.
Limits
| Item | Limit |
|---|---|
| Backup storage location | Alibaba Cloud Object Storage Service (OSS) by default |