Retour
-
Titre
Restore a SQL database from a vRanger Backup. -
Description
It is required to restore a SQL database on a protected VM by vRanger. -
Résolution
Prerequisites:- For application-consistent backups, make sure to review the following KB article: How to Configure VSS Tools in vRanger.
- File Level Restore of MDF and LDF files from the vRanger savepoint (backup file) needs to be performed. For information on how to perform a FLR in vRanger please visit the vRanger Support site | Technical Documentation | User Guide | Restore | Performing an FLR on Windows | Performing a Manual FLR.
- Detach the database in the SQL Instance.
- Place the MDF file and LDF file in the same specific location in the SQL Server, e.g.: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\.
- Open SSMS and go to object explorer of the database engine instance.
- Then make a right click on the database to be restored and select Attach from the menu.
- Windows appears, then click on Add button.
- Select the .mdf file and click on OK Button.
- Validate the selected files and go to OK Button. SSMS will restore the database from the MDF file.