Restoring DB's

[Guest_imported]

I have 2 Databases which I've got by email. They are backup files of databases that run on a far server. I want to make them running on my server too. How do I restore them? I tried restoring but it keep telling me I don't have the right DB (something like that) and when I try to attach these files as databases, it would tell me they're not valid SQL server databases.

The files also don't have extension.

Thanks in advance

 

[foxdev]

it keep telling me I don't have the right DB (something like that)

We'd like to help, but you're going to have to provide a little bit better information. Robert Bradley

http://www.foxdev.com/

Got extra money lying around? Visit:

http://www.agrainofhope.org

 

[Guest_imported]

Here is the more detailed error...

The backup set holds a backup of a database othe than the existing 'MyStore' database.

If you need even more details... just ask!

Thanks

 

[foxdev]

This is caused by the backup set having a database name that already exists in on your server, but the databases (though they have the same name) are different (different structure, for example).

What to do: Overwrite the existing database by reissuing the RESTORE DATABASE command using the WITH REPLACE clause, or restore the backup set to a different database name.

Source: msdn.microsoft.com
Robert Bradley

http://www.foxdev.com/

Got extra money lying around? Visit:

http://www.agrainofhope.org