If you find error no 3154 while restore a SQL database, you can follow below instruction how to solve that. Fyi, Error 3154 in MS SQL means the backup set holds a backup of a database other than the existing database.
How to fixed /Solution
1. Delete the db name that you created manually first.
2. You can use restore sql wizard on SQL studio/query tools like below.
3. Write new db name in “to database” form as picture below.
4. then press ok button
5. wait a minute, your new database will created with restored db inside.