Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How do I import a .bak file into Microsoft SQL Server 2012?

Tags:

sql

sql-server

sql-server-2012

Been Googling this for awhile and no answer....can anyone help?

like image 570
user979331 Avatar asked May 17 '12 14:05

user979331

People also ask

What program do I use to open a BAK file?

How to open a BAK file. You can open a BAK file and use it to restore a SQL Server database in Microsoft SQL Server Management Studio, which is included in Microsoft SQL Server.

1 Answers

For SQL Server 2008, I would imagine the procedure is similar...?

  • open SQL Server Management Studio
  • log in to a SQL Server instance, right click on "Databases", select "Restore Database"
  • wizard appears, you want "from device" which allows you to select a .bak file
like image 80
matt stucky Avatar answered Sep 22 '22 11:09

matt stucky
Sign in to Comment

Related questions

SQL: subquery has too many columns
Explode (transpose?) multiple columns in Spark SQL table
using DateDiff to find duration in minutes
Why are the queries in SQL mostly written in Capital Letters?
Select rows where column value has changed
replace multiple values at the same time - in order to convert a string to a number
Postgres not using index when index scan is much better option
How is data stored in SQL server? [closed]
Entity Framework 6 Code First Trigger
How to quote a string value explicitly (Python DB API/Psycopg2)
Why would an IN condition be slower than "=" in sql?
Oracle table column name with space
Drop Column from Large Table
PostgreSQL HASH index
Join and Include in Entity Framework
SQL - How to transpose?
#1060 - Duplicate column name 'id'
How do I execute a MS SQL Server stored procedure in java/jsp, returning table data?
Adding a static value to the results of an SQL query
How can I drop all indexes in a SQL database with one command?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!