Difference between revisions of "RecoverMSSQL"
From Tranzman Documentation
| Line 3: | Line 3: | ||
==='''Step 1'''=== | ==='''Step 1'''=== | ||
| − | Extract all database files to a temporary location on the client SQL Server | + | Extract all database files to a temporary location on the client SQL Server as a ".BAK" type. |
: '''''i.e. "C:\Temp\New_DB.BAK"''''' | : '''''i.e. "C:\Temp\New_DB.BAK"''''' | ||
==='''Step 2'''=== | ==='''Step 2'''=== | ||
| − | Open MS SQL Management Studio, log in to the instance and | + | Open MS SQL Management Studio, log in to the instance and choose '''restore database'''. |
| − | [[File: | + | [[File:MSSQL_Restore_DB_01.jpg]] |
==='''Step 3'''=== | ==='''Step 3'''=== | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
For the source select From Device, and point it to the BAK file of the New_DB. | For the source select From Device, and point it to the BAK file of the New_DB. | ||
| − | |||
| − | |||
==='''Step 5'''=== | ==='''Step 5'''=== | ||
| − | + | Select '''OK''' and this will restore the contents from the BAK file to the desired Database. | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 11:13, 18 September 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 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.
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.