The backup set holds a backup of a database other than the existing

Hi,
If you encounter this error, it means you are trying to restore a database which is still active.

In order to restore the DB you should run the command with REPLACE command.

If you do it by sql command, add "WITH REPLACE" keyword at the end of the command.

Or if you do by Management Studio, Go to Options on the Left of the Restore screen.

In Restore Options Check "Overwrite the existing database (WITH REPLACE)" checkbox.


Cheers