We use cookies on our website to ensure we provide you with the best experience on our website. By using our website, you agree to the use of cookies for analytics and personalized content.This website uses cookies. More Information
It seems like your browser didn't download the required fonts. Please revise your security settings and try again.
Barracuda Backup

Understanding SQL 2012 VSS based restores.

  • Type: Knowledgebase
  • Date changed: 3 years ago
Solution #00007062  

Scope:
All Barracuda Backup Servers, Firmware 5.4.x and higher.

Answer:

Microsoft VSS is the default backup method for Microsoft SQL 2012 and above. This article applies to customers backing up Microsoft SQL 2012 and above databases using Microsoft VSS. With Microsoft VSS, Barracuda Backup performs full and differential database backups.

Understanding the Restore Dialog Options
Restore to is the Destination Server for the restore location. Note that the restore location must be running the same version of SQL Server and the Barracuda Backup Agent must be installed on the location. There are three options to restore to:
1. Original Location is the original server where the backup came from.
  a. From the drop-down menu, select a different server currently added as a Barracuda Backup data source.
  b. In the restore field, enter the fully qualified domain name (FQDN) or IP address of a server currently on the network
2. Database name displays, by default, the selected database name:
  a. If you are restoring to Original Location, and you want to overwrite the current database, do not change this field.
  b. If you are restoring to an Alternate Location, and you do not want to override the original database, enter a new name for the database in the Database name field.
3. Instance is the database instance:
  a. Original Location is the name of the Instance under which the database resides.
  b. Alternate Location is a different instance on the target server to which to restore the database.
4. Method is the restore method:
  a. Select Restore normally to restore to the original location, and write the .mdf and .ldf files back to that location.
  b. Select Restore to an alternate location to write the .mdf and .ldf files to a different file path that exists on the source server. Enter the path in the associated field, for example, E:\restore. This option must be used if you select to change the database name.
Select Restore to file system to restore a full database to a file (.mdf/.ldf). Enter the restore file path in the associated field, or leave the default value, for example, C:\Microsoft_SQL_Restore_<date>.

Additional Information:
For more information regarding this topic, with screenshots included, please visit https://techlib.barracuda.com/BBS/RestoreMMSQL2012Databases

Link To This Page: