Import .bak file to a database in SQL server

Question

I have a file with .bak extension.

How can I import this date to a database in SQL Server?

Answer 1

1. Connect to a server you want to store your DB
2. Right-click Database
3. Click Restore
4. Choose the Device radio button under the source section
5. Click Add.
6. Navigate to the path where your .bak file is stored, select it and click OK
7. Enter the destination of your DB
8. Enter the name by which you want to store your DB
9. Click OK

Done

Answer 2

You can use node package, if you often need to restore databases in development process.

Install:

npm install -g sql-bak-restore

Usage:

sql-bak-restore <bakPath> <dbName> <oldDbName> <owner>

Arguments:

• bakpath, relative or absolute path to file
• dbName, to which database to restore (!! database with this name will be deleted if exists !!)
• oldDbName, database name (if you don't know, specify something and run, you will see available databases after run.)
• owner, userName to make and give him db_owner privileges (password "1")

!! sqlcmd command line utility should be in your PATH variable.

https://github.com/vladimirbuskin/sql-bak-restore/

Answer 3

RESTORE FILELISTONLY 
FROM DISK = 'D:\3.0 Databases\DB.bak' 

RESTORE DATABASE YourDB
FROM DISK = 'D:\3.0 Databases\DB.bak' 

and you have to move appropriate mdf,ndf & ldf files using

 With Move 'primarydatafilename' To 'D:\DB\data.mdf', 
 Move 'secondarydatafile'To 'D:\DB\data1.ndf', 
 Move 'logfilename' To 'D:\DB\log.ldf'

Answer 4

Simply use

sp_restoredb 'Your Database Name' ,'Location From you want to restore'

Example: sp_restoredb 'omDB','D:\abc.bak'

Answer 5

.bak files are database backups. You can restore the backup with the method below:

How to: Restore a Database Backup (SQL Server Management Studio)

Answer 6

1. Copy your backup .bak file in the following location of your pc : C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA
2. Connect to a server you want to store your DB
3. Right-click Database
4. Click Restore
5. Choose the Device radio button under the source section
6. Click Add.
7. Navigate to the path where your .bak file is stored, select it and click OK
8. Enter the destination of your DB
9. Enter the name by which you want to store your DB
10. Click OK

The above solutions missed out on where to keep your backup (.bak) file. This should do the trick. It worked for me.