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. Example: RESTORE DATABASE Sample FROM DISK = 'C:\Sample.bak' WITH REPLACE ......