Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gsburns
Starting Member
3 Posts |
 Posted - 2004-11-25 : 09:47:11
|
| 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. |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2004-11-25 : 09:57:38
|
| We don't like cross-posts here... Stick to this please:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=43009 |
 |
|
|
|
|
|
Importing data into different data files