Difference between revisions of "Recovery as Normal Files(MSSQL)"
From Tranzman Documentation
| Line 59: | Line 59: | ||
Verify the restored data,once restore has been successful | Verify the restored data,once restore has been successful | ||
| + | |||
[[File:DataRestored.JPG | border|700x600px]] | [[File:DataRestored.JPG | border|700x600px]] | ||
Revision as of 11:14, 16 December 2020
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 and log files. Once you have the files, please follow the steps to restore.
We are demonstrating recovery of data file for AdventureWorks20212 database (shown in below picture).
 |
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.
Step 2
Right Click and select Restore Database.
Step 3
From Device , select the data file to restore.
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.
Step 5
Verify the restored data,once restore has been successful
