Recovery as Normal Files(MSSQL)

From Tranzman Documentation
Revision as of 14:40, 16 December 2020 by Sachin (talk | contribs)
Jump to: navigation, search

Below documentation shows how to restore MS-SQL data after it has been recovered as normal files using steps as shown in Recovery as Normal Files . Please recover the MS-SQL database files (mdf's). Once you have the files, please follow the steps to restore.


We are demonstrating recovery for AdventureWorks20212 database (shown in below picture).


SQLAdventureRestore.JPG


Note.png Note: There are different ways to perform MS-SQL DB restore's like through SSMS or SQL query etc. For more detailed information refer to the Microsoft SQL Database Restore Documentation.


Step 1

Login to SSMS(SQL Server Management Studio) and connect to the SQL Server Instance.


SQL SSMS Connect.JPG


Step 2

Right Click and select Restore Database.


SelectRestoreDatabase.JPG


Step 3

From Device , select the data file to restore.


SelectDataFile.JPG


After that , optionally you can click on Verify Backup Media too.


Step 4

Click on OK and start the restore. Your data should start restoring.


DataRestoreProgress.JPG


Step 5

Verify the restored data,once restore has been successful


DataRestored.JPG


Return to DP/DataProtector Recovery

Retrieved from "https://docs.stoneram.com/index.php?title=Recovery_as_Normal_Files(MSSQL)&oldid=2429"