I had created a new database call db2. Before that i had backup a database 

name db1 to 'c:\db1.bak'.



Is it possible to restore the database db1 to db2. i had tried but error 

occurs - the message something like 'the database db1 is not a database 

file for db2'. 



I believed it was caused of you can't restore the database with different 

database but only with the one you backup, am i correct?



My purpose of doing this is because i have a program (VB) which will 

create a database and the new database will have some default tables in 

it. What i do is i create a dummy database with the table in and when i 

create a new database, i will restore the dummy database to the new 

database and thus the tables in dummy database will also in.



Thanks.