How to import .bak file into Microsoft SQL Server 2012

Posted on November 10, 2017 by Suresh Kamrushi in General

Here I am showing how you can import SQL database file (in “.bak” format) using Microsoft SQL Server Management Studio:
1) Open Studio and connect to the database.
2) Right click on “Database” listed in “Object Explorer” and select “Restore Database”.

Restore_database

3) From the popup select the “device” as “source”.
4) Click on button with “…” on the right side, it will open popup which allows you to select “.bak” file. Here you can select more than one file to be restore.
device_as_source
5) Now click “OK” to restore the database.
It will take some time to import database depending upon the size of the database and get listed automatically under “database” in “object explore”.

Hope it will help someone!!!

Tagged as ,