Restore databse from .bak
Posted on 2009-05-12
Hi I am trying to restore a databse from a bak file taken from a different database using this script
RESTORE DATABASE coreRedHill
FROM Disk = 'E:\CoreRedHill\CorePC 27-04-09.bak'
MOVE 'corepc_Data' TO 'E:\CoreRedHill\coreRedHill.mdf',
MOVE 'corepc_log' TO 'E:\CoreRedHill\coreRedHill_log.ldf'
The database I want to restore is called coreRedHill that back up is taken from a database called corepc.
I am getting this error
The backup set holds a backup of a database other than the existing 'coreRedHill' database.
I have treid using Replace but no joy, can anyone tell me where I am going wrong please?