CloudBerry Backup supports backup and restores for MS SQL databases and files. In this blog post, we will tell how to restore MS SQL data with CloudBerry Backup. Also, you might want to check out our previous article on How to back up MS SQL server to Amazon S3 and other cloud storage.
How to Restore MS SQL Database
1. Run CloudBerry Backup
2. Click on the “Restore” icon.
3. On the “Plan Name” screen select whether to run restore just once or to save a created restore plan for further runs. Click “Next”.
4. For SQL you can choose to Restore MS SQL Server Database or to Restore MS SQL Server backup files. Click “Next”.
5. Select a version of data you want to restore. You can specify a Point in time or choose to restore the Latest version. Click “Next”.
6. Select your SQL Server Instance from the drop-down list and choose the type of Authentication.
7. If you have chosen SQL Server Authentication, specify your Login and Password. Click “Next”.
8. Check appropriate boxes to select databases you want to restore. Click “Next”.
9. If on step 4 you’ve chosen to Restore MS SQL Server Database, your databases will be restored to the destinations of their origin. Specify names for your databases if needed.
Also, you can set CloudBerry Backup to overwrite databases existing in destination folders by checking the “Overwrite the existing database” box.
If on step 4 you’ve chosen to Restore MS SQL Server backup files this step will be skipped.
Once you’re finished, click “Next”.
10. If you’ve chosen to Restore MS SQL Server Database, select Data file folder and Log file folder. Specify a File name template.
If you’ve chosen to Restore MS SQL Server backup files, you will have to specify a destination folder and a backup file template.
When you’re finished, click “Next”.
11. If your data was encrypted on the client side, check the “Decrypt encrypted files with the following password” box. Enter your password and re-enter it to confirm. Click “Next”.
12. If your MS SQL data was backed up to Amazon Glacier, specify the Smart Restore options, otherwise just skip this step.
Note: you can learn more about How to Restore data from Amazon Glacier in another blog post.
13. Next is the “Summary” screen. Overview you MS SQL Restore plan details and click “Next”.
14. Click “Finish” to complete the MS SQL restore plan creation.
Once you’ve created MS SQL restore plan you will be able to run it immediately or whenever you want.