Restore back up to existing database

[micang]

SQL 2000

Hi All,

Not sure exactly which forum this question belongs in. (Maybe setup and administation?)

If I receive a backup file of a database, is there a way of restoring the contents of this back up file into an existing database, but keeping all the tables etc in the existing database intact?

Because the way I see it if I restore the backup file to my existing database, won't it overwrite my whole existing database?

Long story short! I receive a back up which has three tables that I need to get into my database, the way i have been doing it is to restore the back up into a new database, then copy the three tables across to my existing database. Bit of a lengthy process and not sure if there is a better solution. (Like maybe instead receiving the backup file, rather get 3 text files of the 3 databases then just import them into my database).

Many thanks for any input.

Michael

 

[AlexCuse]

I think you're on the right track. Receiving the 3 text files would definitely be preferable though.

Good Luck!

Alex

Ignorance of certain subjects is a great part of wisdom

 

[ptheriault]

If I receive a backup file of a database, is there a way of restoring the contents of this back up file into an existing database, but keeping all the tables etc in the existing database intact?

No. You WILL over write your existing database. You will have to restore that file to another database then import the 3 tables you need.

Unless you have a 3rd party tool like light speed (enterprise edition) there is no way to do single table recovery.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[micang]

Thanks Alex, I agree the txt file would make logical sense.

Michael