System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing

Posted by Sheonarayan under Error and Solution on 7/5/2014 | Points: 10 | Views : 2439 | Status : [Administrator] | Replies : 0

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

[Resolved]

Problem

I was getting "System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing '' database." while restoring database from .bak file to the existing database.

Solution

Go to the Options tab of the Restore Database dialogue box and check "Overwrite the existing database (WITH REPLACE)" checkbox and try to restore again.

It should work.

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

Reply | Reply with Attachment

Alert Moderator

Responses

(No response found.)

Latest Posts

How to find particular URL from within anchor tag using JavaScript or jQuery (0)
How to handle 302 status (Moved temporalily) (1)
Failed to find a valid digest in the 'integrity' attribute (1)
Angular Template parse error occured while rendering 3rd party website in ASP.NET (0)
How to display 2 tables in a single line in 2 div tag (1)
I Want to Do a multiple selector on ASPnet MVC (0)
Get all materials of parent and its children in an array except for few (0)
Container in Media Query (0)
More ...