Difference between revisions of "Recovery as Normal Files(MSSQL)"
From Tranzman Documentation
| Line 1: | Line 1: | ||
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(FileSystem) | Recovery as Normal Files ]]. | 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(FileSystem) | Recovery as Normal Files ]]. | ||
| − | Please recover the MS-SQL database | + | Please recover the MS-SQL database files (mdf's). Once you have the files, please follow the steps to restore. |
| − | We are demonstrating recovery | + | We are demonstrating recovery for AdventureWorks20212 database (shown in below picture). |
Revision as of 14:40, 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 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).
 |
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
