The backup contains everything, including the schema. The easiest thing to do in your situation is to delete the empty database that you created and restore the backup. You may have to change the location of the database files. If you're using the SEM, you can do that on the Options tab (I think that's the name.) If you're using the TSQL RESTORE command, use the MOVETO option.

-Mike


>Hi all:
>
>I'm trying to restore a backup from our production server to another machine (my notebook computer) to have a parallel development situation. I have created an empty database on the target machine by generating a script of the source db and running it on the target machine. After doing this, however, when I attempt to restore, I get the following error:
>
>"The backup set holds a backup of a database oterh than the existing 'ClosingBoard' database. Backup or restore operation terminating abnormally."
>
>Surely there must be a way to accomplish what I am trying to do. I am using SQL7.
>
>Thanks,
>
>Del