Sunday, February 19, 2012

Error while restoring database,

Hi,
Im trying to restore a database, when i try to restore by selecting the file groups option it gives me an error Microsoft SQL DMO The backup set holds a backup of a database other than the existing database. RESTORE DATABASE terminated abnormally.
I tried deleting all the tables and the stored procedures that are there, but it still gives the same error.I got this message, too.

In the Options tab, check "Force Restore over existing database".|||Where is this option located?
I'm using SQL Express|||

Tell me. why do I need to check the option "Override the existing database"?

Thanks for the answer

|||If you check "Force Restore over existing database", it must works.|||In Express, click Options on the left and check the field called 'Overwrite the Existing Database'. Also, you may need to change the mdf and log file names to your new database.|||

I had a similar problem, but I was trying to restore the ".bak" file from my laptop to my pc. I had copied the file my pc My Documents folder and tried to restore from SQL Management Express, kept getting the same error. Eventually i tried placing the file in the original backup location it was created but this time on the pc i.e. "C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup" then it worked. Not sure what's the reason for this but just thought I’d share since I know someone else is probably bursting their heads over the same issue..

|||Setting the "Overwrite existing database" fix the problem for me

Thanks for the pointer.|||

I was getting the following error and ur solution worked fine here, Thx a lot!

"The backup set holds a backup of a database other than the existing database."

No comments:

Post a Comment