Recovery as Normal Files(MSSQL) - Revision history

Sachin at 08:41, 26 May 2021

2021-05-26T08:41:37Z

Sachin at 14:40, 16 December 2020

2020-12-16T14:40:39Z

Sachin at 11:15, 16 December 2020

2020-12-16T11:15:28Z

Sachin at 11:14, 16 December 2020

2020-12-16T11:14:44Z

Sachin at 11:12, 16 December 2020

2020-12-16T11:12:48Z

Sachin at 11:11, 16 December 2020

2020-12-16T11:11:41Z

Sachin at 10:12, 15 December 2020

2020-12-15T10:12:43Z

Sachin: Created page with " 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 | Recovery as Normal File..."

2020-12-15T10:12:10Z

Created page with " 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 | Recovery as Normal File..."

New page

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 | Recovery as Normal Files ]].

← Older revision		Revision as of 08:41, 26 May 2021
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.
		+
		+	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.		Please recover the MS-SQL database files (mdf's). Once you have the files, please follow the steps to restore.

@@ 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 ]].
-Please recover the MS-SQL database and log files. Once you have the files, please follow the steps to restore.
+Please recover the MS-SQL database files (mdf's). 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).
+We are demonstrating recovery for AdventureWorks20212 database (shown in below picture).

@@ Line 22: / Line 22: @@
-[[File:SQL_SSMS_Connect.JPG | border|700x600px]]
+[[File:SQL_SSMS_Connect.JPG | border|900x700px]]
@@ Line 31: / Line 31: @@
-[[File:SelectRestoreDatabase.JPG | border|700x600px]]
+[[File:SelectRestoreDatabase.JPG | border|900x700px]]
@@ Line 40: / Line 40: @@
-[[File:SelectDataFile.JPG | border|700x600px]]
+[[File:SelectDataFile.JPG | border|900x700px]]
@@ Line 52: / Line 52: @@
-[[File:DataRestoreProgress.JPG | border|700x600px]]
+[[File:DataRestoreProgress.JPG | border|900x700px]]
@@ Line 61: / Line 61: @@
-[[File:DataRestored.JPG | border|700x600px]]
+[[File:DataRestored.JPG | border|900x700px]]
 [[ DP/DataProtector Recovery | Return to DP/DataProtector Recovery ]]

← Older revision		Revision as of 11:14, 16 December 2020
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]]

@@ Line 32: / Line 32: @@
 [[File:SelectRestoreDatabase.JPG | border|700x600px]]
@@ Line 37: / Line 38: @@
 From Device , select the data file to restore.
 [[File:SelectDataFile.JPG | border|700x600px]]
 After that , optionally you can click on Verify Backup Media too.
@@ Line 49: / Line 53: @@
 [[File:DataRestoreProgress.JPG | border|700x600px]]

← Older revision		Revision as of 11:11, 16 December 2020
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 ]]

← Older revision		Revision as of 10:12, 15 December 2020
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 \| 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 ]].