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.

[370 byte] By [DrZombie] at [2008-2-13]

«« like command
»» Dataset As Parameter

# 1

I got this message, too.

In the Options tab, check "Force Restore over existing database".

David.Liu at 2007-9-8 >

top of Msdn Tech,SQL Server,SQL Server SMO/DMO...

# 2

Where is this option located?
I'm using SQL Express

MarkleSparkle at 2007-9-8 >

# 3

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

Thanks for the answer

RenzoRuiz at 2007-9-8 >

# 4

If you check "Force Restore over existing database", it must works.

RedMaple at 2007-9-8 >

# 5

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.

hornerj99 at 2007-9-8 >

# 6

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..

Demonite at 2007-9-8 >

# 7

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

Thanks for the pointer.

cmsturg at 2007-9-8 >

# 8

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."

asawaf at 2007-9-8 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

it's Archive about 'Error while restoring database,...'

Error while restoring database,

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Site Classified