SQL DATABASE BACKUP and RESTORE WITH RDS
Backup and Restore: SQL Database:
Create a "warm" backup
Move the backup file to a different server, preferably in a different location.
Automate the process. Using an unattended process, with monitoring capabilities, like sending an e-mail in case of an error, provides a reliable solution.
The solution: SQL databse backup & restore with RDS
The backup file is being replicated to a target machine (RDS Satellite) using RDS.
The whole process of stopping the SQL server, backing it up and re-starting the SQL server is performed automatically on the source machine (RDS Controller) using pre-replication-command.
Using this process, if the backup fails for some reason, the replication will not be performed, keeping the target system with the last successful SQL backup.
Once the backup file reaches its destination, the backup file needs to be restored to the target SQL database. Here too, the process is automated using the post-replication-command, on the target machine (RDS Satellite).
The batch file will take care of stopping the target SQL server, restoring the backup file and re-starting the target SQL server.
In the event of an error in any of the stages of the process, appropriate actions can be taken - the replication job can be halted based on various pre-defined parameters, so the last backup remains intact in case of an error during the process.
The administrator can receive an e-mail notifying that there was a problem during the backup operation, attaching the job reports.
This distinct process, using RDS as the platform to backup-transfer-restore the SQL database, enables complete automation and easy monitoring of the whole operation, ensuring a comprehensive backup process.
|
