Cannot restore

I have backed up a database created a .bak.
Now I created another database with other name. Then tried to restore the
.bak file into this new database.
However, I got an error:
"The backup set int file 'D:\Temp\Employee.bak' was created by BACKUP
DATABASE...FILE=<name>
and cannot be used for this restore operation.
RESTORE DATABASE is terminating abnormally.
Any idea?Alan
How many files the .BAK file is contain?
Check out 'WITH MOVE...' command in the BOL
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:%235AfdvxoGHA.4996@.TK2MSFTNGP05.phx.gbl...
>I have backed up a database created a .bak.
> Now I created another database with other name. Then tried to restore the
> .bak file into this new database.
> However, I got an error:
> "The backup set int file 'D:\Temp\Employee.bak' was created by BACKUP
> DATABASE...FILE=<name>
> and cannot be used for this restore operation.
> RESTORE DATABASE is terminating abnormally.
> Any idea?
>|||Sorry, what do you mean by "How many files the .BAK file is contain" ?
I tried to restore in EM and got the error.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OYsjJ1yoGHA.524@.TK2MSFTNGP05.phx.gbl...
> Alan
> How many files the .BAK file is contain?
> Check out 'WITH MOVE...' command in the BOL
>
>
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:%235AfdvxoGHA.4996@.TK2MSFTNGP05.phx.gbl...
>|||Alan T wrote:
> Sorry, what do you mean by "How many files the .BAK file is contain" ?
> I tried to restore in EM and got the error.
>
You might have to use the REPLACE option if you want to overwrite an
existing database and use WITH MOVE if the files has to be moved to
another location. Try looking up RESTORE DATABASE in Books On Line. Here
you can find the syntax.
Regards
Steen Schlter Persson
Databaseadministrator / Systemadministrator