I have a SQL Server 2005 database backup file (.bak), and I want to grab the data of this file and import it to an already existing database. Since the backup file contains database information as well, a simple Restore
doesn't seem to work - because it needs the database, from which the backup was made, to be present.
How can I resolve this issue in a quick and easy way? I have access to the 2005 database as well, if I need to create the backup in a different manner.
The two SQL Server instances runs on different machines.