Error restoring database


Story by Abhilash on SQL Server

Share   

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: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=15.0.18206.0+((SSMS_Rel).191029-2112)&LinkId=20476

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.

Thanks.

 

 








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.