Replicate a Database - HHHEEELLLLP!!!
Posted on 2012-09-10
I am a bit new to this so please keep that in mind.
I have a database (Centrispoint). I want to create a new database (Bridger). I then want top copy the Centrispoint database to Bridger as a copy.
Here is what I did using the Management Studio
1) Backed up the Centrispoint DB (FULL) - OK
2) Created the Bridger DB - OK
3) Attempted to restore the Bridger DB using the Centrispoint DB.
Here is the "script generated:
RESTORE DATABASE [Bridger] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Centrispoint.bak'
WITH FILE = 52, NOUNLOAD, STATS = 10
I received an error:
Msg 3154, Level 16, State 4, Line 1
The backup set holds a backup of a database other than the existing 'Bridger' database.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
This is a correct statement from SQL Server! How do I proceed?
Thanks in advance,