How to copy one database into another under MSSQL Server 2005
Posted on 2009-04-02
Looks like a simple task.
I select a database, then rightclick and select backup, then select a target file and backup is successful.
Next I create a new database, and wishing to import the previously backup database I select "Restore" and then select the file that contains the newly created backup.
Restore won't succeed however, saying that "The backup set holds a backup of a database other than the existing..."
That makes sense, but there must be a way just to copy structure as well asw data to a new database.