PDA

View Full Version : How to import a bak file into SQL Server Express


ABC123

tim205
08-24-2010, 04:56 PM
Hi,

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

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

Thanks,
Tim

mumfie
09-01-2010, 04:06 AM
Hi,

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

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

Thanks,
Tim
You can use Microsoft SQL management studio or other similar tools.

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