Difference between revisions of "RecoverMSSQL"

From Tranzman Documentation
Jump to: navigation, search
Line 9: Line 9:
  
 
Open MS SQL Management Studio, log in to the instance and create a new Blank Database.
 
Open MS SQL Management Studio, log in to the instance and create a new Blank Database.
 +
 
[[File:MSSQL_New_DB.jpg]]
 
[[File:MSSQL_New_DB.jpg]]

Revision as of 10:58, 29 August 2018

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 and rename them to a ".BAK" type. i.e. C:\Temp\New_DB.BAK

Step 2

Open MS SQL Management Studio, log in to the instance and create a new Blank Database.

MSSQL New DB.jpg