Rajeev Pentyala – Microsoft Power Platform

I got below error, when I was trying restore a database from Azure Blob Storage to my local SQL server using ‘SQL Server Management Studio (SSMS)’.

System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing ‘{DB_Name}’ database. (Microsoft.SqlServer.SmoExtended)

Reason:

• I created a new Database (DB) first and tried to restore the DB from Azure blob to this new DB.

Fix:

Below approach solved the issue

• Don’t create a new Database before hand.
• Right click ‘Databases’ and select ‘Restore Database’
• Pick your ‘Source’ Database
• In the ‘Destination’ section, provide a new Database name as highlighted below

• Click ‘OK’ to complete the Restore process.

If you want to create a Blank Database first and restore.

• Set below settings in ‘Options’ tab of ‘Restore Database’ window

• Pick existing Database
• Click ‘OK’ to complete the Restore process.

🙂