Barracuda Backup Service version 3.1 and newer.
To restore a SQL user database to an alternate machine with the Barracuda Backup Service there are a couple of requirements that need to be in place first.
- Microsoft SQL needs to be installed and running on the target system.
- The instance to be restored to has to be the same name and type as the source instance. Note: if the default instance was used then the target needs to have a default instance if a named instance was used then the target needs a named instance by the same name.
- The file path used as part of the source database must be present on the target system. Meaning that if the database was at "F:\SQL\Mydatabase.mdf" the target system must have an F drive with a folder titled SQL there. This can be worked around by creating a database in this instance by the same name as the source database. The restore process will use the path of the existing database instead of trying to recreate the original one.
- The Barracuda Backup agent must be installed on the target machine.
When you request the restore of a Microsoft SQL Server user database, Barracuda Backup performs all of the restores required to get to the desired date, as follows:
- Restore a full backup of the SQL Server database
- Restore the incremental backups in the order in which they were created
In other words, if you want to restore the database to a certain date, simply select the date and that database, and Barracuda Backup restores all intermediate required database revisions.
Use the following steps to restore a Microsoft SQL user database,
- On the Restore > Restore Browser page, select the day and time from which you want to restore.
- Select the data source from which you want to restore.
- Select the database(s) to restore, and click Restore.
Link to this page: