Geeks With Blogs
Shravan's Articles on .NET A .NET Blog

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

Posted on Sunday, June 6, 2010 7:12 PM SQL Server | Back to top

Copyright © Shravan Kumar | Powered by: GeeksWithBlogs.net