CloudBerry Backup supports backup and restore 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 the 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 the 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 client side, check the “Decrypt encrypted files with the following password” box. Enter your password and re-enter in 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.
Note: this post applies to CloudBerry Backup for MS SQL Server 3.7 and later.