Fixing SQL Server Error : The backup set holds a backup of database other than the existing database.

We faced this error while restoring a database in Sql Server using the .bak(backup)  file but into a different database.

The way it was resolved for us was to

1) Selecting Options within Restore Database dialog box.

2) Specifying correct path to the mdf and log file for the database.

3) Checking Overwrite the existing database option.

That’ s it ..


Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology !

15 thoughts on “Fixing SQL Server Error : The backup set holds a backup of database other than the existing database.”

  1. wao perfect thanx for this help.. i not like the MSQL and it take my hr to find the correct way to restore the database in other DB..

    realy thanxxx

    Like

Share your thoughts

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s