How to import .bak file into Microsoft SQL Server 2012
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".
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.
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!!!
Your feedbacks are most welcome..
Recent Posts
- Cordova twitter post on behalf of user
- Sending push notifications to Android mobile using Firebase and PHP
- Telegram Bot: Insert line break to text message
- Telegram Bot message formatting
- Removing index.php from url of codeigniter-3 ubuntu
- Generating ERD using PHPMyAdmin 4.9
- C# : Adding a new column in datatable and adding value to it
- Getting rows count for each table in Database in SQL server
Ads