Thank you all for your help.

It is now working =)

Graeme


"John Bell" <jbellnewsposts@hotmail.com> wrote in message news:<q3KAb.1615$Zi7.30961769@news-text.cableinet.net>...
> Hi
>
> There are plenty of references to "The backup set holds a backup of a
> database other than the existing" if you search Google.
>
> You don't specify if you have created the new database before trying to
> restored (which is not necessary!) If the file locations of the old database
> do not correspond with the file location of the new database, you may get
> this message if you do not change the locations. You may also need to
> specify the overwrite option.
>
> John
>
>
> "Graeme" <mister_grimmy@hotmail.com> wrote in message
> news:932b7087.0312070921.6fa57449@posting.google.c om...
> > Hi all,
> >
> > I have a .BAK file which i need to restore. It originally came from
> > another machine and I am now trying to restore the DB.
> >
> > When i try to restore the bak file using enterprise manager i receive
> > the following message...
> >
> > "The backup set holds a backup of a database other than the existing
> > "SAP" database. Restore Database is terminating abnormally"
> >
> > Can anyone help me with this?
> >
> > Thanks in advance,
> > G