Msg 3154, Level 16, State 4, Server YourDatabaseName, Line 1

This error tells you that the database being restored is already existing in the server. Use WITH REPLACE or Change the database Name which you are restoring.

RESTORE DATABASE YOURDATABASENAME FROM DISK='D:\YOURDB.BAK' WITH REPLACE