Restore DB Error:

Hi,
I'm trying to do a backup which works fine and then when it gets to the restore it crashes with error message:


Msg 3154, Level 16, State 4, Line 8

The backup set holds a backup of a database other than the existing 'CompsnapTestBackup' database.

Msg 3013, Level 16, State 1, Line 8

RESTORE DATABASE is terminating abnormally.

HERE IS MY CODE:


use master

GO

--BACKUP DATABASE CompsnapTest

--TO DISK= 'C:TestCompsnapTestBackup.bak' ;

--RESTORE FILELISTONLY

--FROM DISK= 'C:TestCompsnapTestBackup.bak' ;

RESTORE DATABASE CompsnapTestBackup

FROM DISK= 'C:TestCompsnapTestBackup.bak'

WITH MOVE 'CompsnapTest_Data' TO 'C:TestTest2CompsnapTestBackup.mdf',

MOVE 'CompsnapTest_Log' TO 'C:TestTest2CompsnapTestBackup.ldf';

GO



thanks,