Restore a SQL database from a vRanger Backup. (4369112)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

Restore a SQL database from a vRanger Backup.
Beschreibung

It is required to restore a SQL database on a protected VM by vRanger.
Lösung
Prerequisites:
- For application-consistent backups, make sure to review the following KB article: How to Configure VSS Tools in vRanger.
1. 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.
2. Detach the database in the SQL Instance.
3. 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\.
Restore the Database from the MDF file using SQL Server Management Studio:
1. Open SSMS and go to object explorer of the database engine instance.
2. Then make a right click on the database to be restored and select Attach from the menu.
3. Windows appears, then click on Add button.
4. Select the .mdf file and click on OK Button.
5. Validate the selected files and go to OK Button. SSMS will restore the database from the MDF file.

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Artikelhistorie:: Erstellt am: 10/17/2022
Letzte Aktualisierung am: 5/7/2023

Titel