Importing data into different data files

I have 2 SQL Server databases called Demo and Dev. I exported Demo (as Demo.bak) and want to import it into Dev. When I use Restore Database in Enterprise Manager specifying the From device it automatically chooses the Demo logical and physical data file names (in the Options tab of Restore database) instead of Dev logical and physical data file names and so it would overwrite the existing data in Demo (not the same as the export in Demo.bak)

Is there a way I can specify which data files I want the data to be imported into?

The Import Data wizard does not work as there is not an option to specify the Data Source as a .bak file.

I need to use the Demo.bak file as I no longer have access to Demo database.

Can anyone help please?

Many thanks.

Hi,

When restoring, choose 'From Device'
Then click on 'select Devices....'
Make sure the Disk radio button is selected and click on Add
Make sure the File Name radio button is selected, and click button next to file name '....'
Make sure you .bak file is located on the server, on one of the disk (make no real difference)
In the 'Backup Device Location' window, browse folders and select the file to restore.
Make sure you 'restore as database' is the correct database name.
make sure you have 'ticked' the force restore over existing database in the Options tab.

Try this, i hope this is what you wanted...let me know if you have any probs.

Cheers

Mez