The backup set holds a backup of a database other than the existing database (Microsoft SQL Server,
- by Shravan
Fewdays back i took the backup of my development server, I am trying to restore it in my own system. I am getting the following error.
The backup set holds a backup of a database other than the existing 'sample' database. RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3154)
I found a following solution form pinal dev blog. It's very simple.
Ex:
RESTORE DATABASE Sample
FROM DISK = 'C:\Sample.bak'
WITH REPLACE