Shravan Kumar Kasagoni

Skip Navigation
The backup set holds a backup of a database other than the existing database (Microsoft SQL Server, Error: 3154)

The backup set holds a backup of a database other than the existing database (Microsoft SQL Server, Error: 3154)

 /  Leave a response

Long back I took the backup of my development server, Again I am trying to restore it in my own machine or any other machine, 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 very simple solution form Pinal Dave blog.

Run the following commands in SQL:


RESTORE DATABASE Sample

FROM DISK =‘C:\Sample.bak’

WITH REPLACE

Write a response

Your email address will not be published. Required fields are marked *

All code will be displayed literally.

Close Bitnami banner
Bitnami