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

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

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!

Donate Us With