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 "icon"--> "Restore". 


2. Select a backup version that you want to restore.

Select Content

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.

Restore to Original Location

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.

Restore to New Location

4. After all settings are completed, click "Start Restore" to begin the restore progress.

Start Restore

5. The restore is running, please wait patiently for the restore to complete. You can click on the "icon" 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.

Restore Result

Tips: You can also restore from "Backup Management"-->"History Versions".


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.


  • "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