Community TechDays in your city

ctd

Dive deep into the world of Microsoft technologies at the Community TechDays (CTD) and get trained on the latest from Microsoft. Build real connections with Microsoft experts and community members, and gain the inspiration and skills needed to maximize your impact on your organization while enhancing your career. What more… you can watch some of these sessions LIVE online from the comfort of your workstation as well.

Attend CTD in Hyderabad on December 18th 2010. For more info on CTD in other cities: http://www.communitytechdays.com

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

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 very simple solution form Pinal Dave blog.

Run the following commands in SQL

RESTORE DATABASE Sample

FROM DISK =‘C:Sample.bak’

WITH REPLACE