![restore production mananger files in flexi 12 restore production mananger files in flexi 12](https://1.bp.blogspot.com/-edKBpx3wS-M/Xktc6OFKyAI/AAAAAAAAdAc/uyaR86eIPZ8zyUAGduqeaRsY6i70OEkvACLcBGAsYHQ/s1600/Untitled613.png)
This option is only available if you have already connected to a SQL Server instance. You can also start the SQL Virtual Restore wizard directly from SQL Server Management Studio, by selecting Tools > SQL Virtual Restore from the main menu: See Working with the HyperBac Control Service for more information.įrom the Start menu (on the SQL Server you want to virtually restore to), select All Programs > Red Gate > HyperBac > SQL Virtual Restore Wizard The backup file in this example was created using SQL Backup, but you can follow this example using a backup file in any supported format.īefore you start, check that the HyperBac Control Service is running on the SQL Server you want to virtually restore to. SQL Virtual Restore works with backup files in SQL HyperBac format, SQL Backup format (version 6 and above), and native SQL Server format.
Restore production mananger files in flexi 12 full#
Worked example: creating a database using the SQL Virtual Restore wizardįor this worked example, we'll virtually restore from a full backup of the sample "AdventureWorks" database. This method is more flexible (enabling you to virtually restore to a specific point in time using transaction log backup files, for example), but you must ensure that the HyperBac Control Service is configured correctly, and write the necessary T-SQL RESTORE commands yourself.Įach method is described in the following sections. Use native T-SQL commands to virtually restore backup files.Use the SQL Virtual Restore wizard, which guides you through each step, and also ensures that the HyperBac Control Service is configured correctly.You can use either of the following methods to create a database by virtually restoring backup files:
![restore production mananger files in flexi 12 restore production mananger files in flexi 12](https://d6vfwwsmhxo8w.cloudfront.net/previews/3324_0000_1adaff677fae8a6d88af8fccde469a5b_640x360.jpg)
Provided the service is configured correctly, it will automatically intercept and process data from your backup files, and create your database. To access the data in backup files using SQL Virtual Restore, you must perform a restore operation that the HyperBac Control Service recognizes as a virtual restore.