The backup set holds a backup of a database other than the existing database (Microsoft SQL Server,
Posted
by Shravan
on Geeks with Blogs
See other posts from Geeks with Blogs
or by Shravan
Published on Sun, 06 Jun 2010 13:12:18 GMT
Indexed on
2010/06/06
13:52 UTC
Read the original article
Hit count: 217
Filed under:
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
© Geeks with Blogs or respective owner