Restore of database ‘SambaPOS4’ failed.
The backup set holds a backup of a database other than the existing ‘SambaPOS4’ database.
The error you are getting during restore of DB with SSMS can be overcome if you look at the Options portion of the Restore dialog, and check these boxes (the first box is the important one for that error message, but it doesn’t hurt to check the other one as well):
You also have the option to relocate the physical DB files (MDF and LDF files) during a SSMS restore using the Files portion of the Restore dialog. This has nothing to do with the error, and is rarely necessary…
SambaPOS has a similar option to overcome the error, allowing overwrite…
