SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 07:07 PM
| ||||
| ||||
 Newbie Question: Restoring BAK file into a new server 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      |
|
02-28-2008, 07:07 PM
| |||
| |||
| Re: Newbie Question: Restoring BAK file into a new server The message is telling you that a database of that name already exists on the server you are restoring to. If you are certain that you want to overwrite that database, use the command RESTORE ... WITH REPLACE. -- David Portas ------------ Please reply only to the newsgroup -- |
|
02-28-2008, 07:07 PM
| |||
| |||
| Re: Newbie Question: Restoring BAK file into a new server 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 |
|
02-28-2008, 07:07 PM
| ||||
| ||||
| Re: Newbie Question: Restoring BAK file into a new server 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 |
 |
« error 1012: the correlation name '%' has the same exposed name as table '%'.
|
Need Help for query »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 08:47 PM.
