Difference between revisions of "Recovery as Normal Files(MSSQL)"
| (3 intermediate revisions by the same user not shown) | |||
| 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 ]]. | ||
| − | |||
| + | Depending on, the way backups were done SQL backup files could be recovered as .bak files or the mdf's. | ||
| − | We are demonstrating recovery | + | Below we have demonstrated both ways of performing SQL restores, if your have .bak files recovered using Tranzman and also if you have recovered the mdf's using Tranzman. |
| + | |||
| + | |||
| + | |||
| + | 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). | ||
| Line 22: | Line 29: | ||
| − | [[File:SQL_SSMS_Connect.JPG | border| | + | [[File:SQL_SSMS_Connect.JPG | border|900x700px]] |
| Line 31: | Line 38: | ||
| − | [[File:SelectRestoreDatabase.JPG | border| | + | [[File:SelectRestoreDatabase.JPG | border|900x700px]] |
| Line 40: | Line 47: | ||
| − | [[File:SelectDataFile.JPG | border| | + | [[File:SelectDataFile.JPG | border|900x700px]] |
| Line 52: | Line 59: | ||
| − | [[File:DataRestoreProgress.JPG | border| | + | [[File:DataRestoreProgress.JPG | border|900x700px]] |
| Line 60: | Line 67: | ||
Verify the restored data,once restore has been successful | Verify the restored data,once restore has been successful | ||
| − | [[File:DataRestored.JPG | border| | + | |
| + | [[File:DataRestored.JPG | border|900x700px]] | ||
[[ DP/DataProtector Recovery | Return to DP/DataProtector Recovery ]] | [[ DP/DataProtector Recovery | Return to DP/DataProtector Recovery ]] | ||
Latest revision as of 08:41, 26 May 2021
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 .
Depending on, the way backups were done SQL backup files could be recovered as .bak files or the mdf's.
Below we have demonstrated both ways of performing SQL restores, if your have .bak files recovered using Tranzman and also if you have recovered the mdf's using Tranzman.
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
