RecoverMSSQL

From Tranzman Documentation
Revision as of 11:14, 18 September 2018 by Admin (talk | contribs)
Jump to: navigation, search

The following method has been tested with the versions of Microsoft SQL 2008,2012 & 2014 for recovering the Database Files and getting the server back up and running.

Step 1

Extract all database files to a temporary location on the client SQL Server as a ".BAK" type.

i.e. "C:\Temp\New_DB.BAK"

Step 2

Open MS SQL Management Studio, log in to the instance and choose restore database.

MSSQL Restore DB 01.jpg

Step 3

For the source select From Device, and point it to the BAK file of the New_DB.

Step 5

Select OK and this will restore the contents from the BAK file to the desired Database.


Use this link to go back to the main recoverydocs Page.