How to Restore Microsoft SQL Server with AOMEI Cyber Backup
You may need to restore your database in many cases, for exmaple, database crash, system corruption, data loss, and so on. With the help of AOMEI Cyber Backup, you can easily restore the database you backup. It will recover your data and save your time.
In this article, we will introduce how to restore the backups of database created by AOMEI Cyber Backup.
How to Restore Backups of Microsoft SQL Server
Prerequisites for Microsoft SQL Server restore:
- Computer with AOMEI Cyber Backup installed
- Computer with AOMEI Cyber Backup Agent and Microsoft SQL Server installed
- Database backups created by AOMEI Cyber Backup
Once you have created backups for your Microsoft SQL Server database, you can restore them at any time.
1. Click "Backup Task" on the left menu bar, locate the task you want to restore, and click "
"--> "Restore".
2. Select a backup version that you want to restore.
3. Select the target location that you want to restore to.
If you restore to original location, you don’t need to select target. "Restore to original location" is selected by default, you can directly click "Start Restore".
Tips: If you tick the option "Overwrite the database with the same name", the detected database with the same name will be overwritten automatically when restoring. Otherwise, the database with the same name will be skipped.
If you restore to new location, you need to select target and specify the name of the new database. You can also modify the storage location.
4. After all settings are completed, click "Start Restore" to begin the restore progress.
5. The restore is running, please wait patiently for the restore to complete. You can click on the "" button to see restore details or cancel the restore.
6. After the restore is complete, you can see the restored database in Microsoft SQL Server Management Studio.
Tips: You can also restore from "Backup Management"-->"History Versions".
Summary
After the restoration is successful, the database will be in the previous state. This prevents the loss of important data and is very secure and hassle-free.
Notes:
- "Restore to original location" must confirm the original location exist. Or else, you can only select "Restore to new location".
- "Restore to original location" will overwrite or delete the original database data, if the original database has important data, it is recommended to choose "Restore to new location".
- If your backup tasks are accidentally deleted, or you need to restore backups created on another computer, you will need to select backup files manually to restore.