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 : 2880 | 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 white label Uber app clone can help you start a taxi business like Uber? (0)
Iterating over columns of dataframe and print as rows in Python Django (0)
Where can I found sample MVC projects to learn and improve skills (1)
Extract a value from HTML string (0)
Get only year part from date string in SQL server (0)
django.template.exceptions.TemplateDoesNotExist: AlgoDash/index.html (0)
How to find particular URL from within anchor tag using JavaScript or jQuery (0)
How to handle 302 status (Moved temporalily) (1)
More ...