How to import a bak file into SQL Server Express

Sql Server Sql Server-2008 Database Backups Database Restore

Sql Server Problem Overview

I have a .bak file, and I want to use this file to recreate the database in a fresh install of SQL Server 2008 Management Studio.

Can someone point me in the right direction on how this can be done?

I have tried:

right click on the Databases container within object explorer
from context menu select Restore database
Specify To Database as either a new or existing database
Specify Source for restore as from device
Select Backup media as File
Click the Add button and browse to the location of the BAK file

but I am getting error that

> Restore failed for Server 'MyServer-PC'. (Microsoft.SqlServer.SmoExtended) > > ADDITIONAL INFORMATION: > > System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'invent' database. (Microsoft.SqlServer.Smo)

Sql Server Solutions

Solution 1 - Sql Server

There is a step by step explanation (with pictures) available @ Restore DataBase

Click Start, select All Programs, click Microsoft SQL Server 2008 and select SQL Server Management Studio.
This will bring up the Connect to Server dialog box.
Ensure that the Server name YourServerName and that Authentication is set to Windows Authentication.
Click Connect.
On the right, right-click Databases and select Restore Database.
This will bring up the Restore Database window.
On the Restore Database screen, select the From Device radio button and click the "..." box.
This will bring up the Specify Backup screen.
On the Specify Backup screen, click Add.
This will bring up the Locate Backup File.
Select the DBBackup folder and chose your BackUp File(s).
On the Restore Database screen, under Select the backup sets to restore: place a check in the Restore box, next to your data and in the drop-down next to To database: select DbName.
You're done.

Solution 2 - Sql Server

To do this via TSQL (ssms query window or sqlcmd.exe) just run:

RESTORE DATABASE MyDatabase FROM DISK='c:\backups\MyDataBase1.bak'

To do it via GUI - open SSMS, right click on Databases and follow the steps below

enter image description here

Solution 3 - Sql Server

Using management studio the procedure can be done as follows

right click on the Databases container within object explorer
from context menu select Restore database
Specify To Database as either a new or existing database
Specify Source for restore as from device
Select Backup media as File
Click the Add button and browse to the location of the BAK file

refer

You'll need to specify the WITH REPLACE option to overwrite the existing adventure_second database with a backup taken from a different database.

Click option menu and tick Overwrite the existing database(With replace)

Reference

Solution 4 - Sql Server

I had the same error. What worked for me is when you go for the SMSS GUI option, look at General, Files in Options settings. After I did that (replace DB, set location) all went well.

Solution 5 - Sql Server

Restoring a Database from Backup

sql-server-->connect to instance-->Databases-->right-click on databases-->Restore
            DataBase..-->Device-->Add-->choose the path_filename(.bak)-->click OK

Content Type	Original Author	Original Content on Stackoverflow
Question	Ashok	View Question on Stackoverflow
Solution 1 - Sql Server	Al-3sli	View Answer on Stackoverflow
Solution 2 - Sql Server	viggity	View Answer on Stackoverflow
Solution 3 - Sql Server	Nagaraj S	View Answer on Stackoverflow
Solution 4 - Sql Server	DIKKEHENK	View Answer on Stackoverflow
Solution 5 - Sql Server	vhadalgi	View Answer on Stackoverflow