Difference between revisions of "Recovery as Normal Files(MSSQL)"

From Tranzman Documentation
Jump to: navigation, search
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 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).
 +
 +
 +
[[File:SQLAdventureRestore.JPG | border|700x600px]]
 +
 +
 +
{|style="padding: 5px; width: 85%;"
 +
| style="width: 1%;"|[[File:Note.png|30px]]|| style="padding: 10px; width: 85%;"|'''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.
 +
 +
 +
[[File:SQL_SSMS_Connect.JPG | border|700x600px]]
 +
 +
 +
 +
===Step 2===
 +
 +
Right Click and select Restore Database.
 +
 +
 +
[[File:SelectRestoreDatabase.JPG | border|700x600px]]
 +
 +
 +
===Step 3===
 +
 +
From Device , select the data file to restore.
 +
 +
[[File:SelectDataFile.JPG | border|700x600px]]
 +
 +
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.
 +
 +
 +
[[File:DataRestoreProgress.JPG | border|700x600px]]
 +
 +
 +
===Step 5===
 +
 +
Verify the restored data,once restore has been successful
 +
 +
[[File:DataRestored.JPG | border|700x600px]]
 +
 +
 +
 +
[[ DP/DataProtector Recovery | Return to DP/DataProtector Recovery ]]

Revision as of 11:11, 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).


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