Error restoring database

Story by Abhilash on SQL Server


Last night, I was restoring database from backup. For some reasons, I got an error as below:

System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'database-name' database. (Microsoft.SqlServer.SmoExtended)
For help, click:

After scratching head for sometime, I realized that I was trying to restore the database backup to an empty database. Silly me! I tried restoring database backup from Databases tree in Object Explorer and it worked like a charm.




comments powered by Disqus

Related Story   →

Fix: HTML5 Video not playing when deployed to azure

A post on how to playback HTML5 video when published to Azure.