question

ballack avatar image
ballack asked

About restore database

I have a question regarding to database Backup and restore . Is it possible to restore two different databases backups into one database without replacing tables that are already available in the existing database? example : i have tarak1 database with table name info1 tarak2 database with table name info2 tarak3 database with table name info3 is it possible to restore tarak2 and tarak3 databases into tarak1 database ? also , i need to have all three tables available in tarak1 databse after restore
restore
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ballack avatar image ballack commented ·
Thanks for giving me a right direction..
0 Likes 0 ·
Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
With a restore, you either replace the existing database, or you can restore into a new database. There are tools, which I'm not too familiar with, with which you can perform an object level restore. If you don't have such tool, you can do this: Restore tarak2 and tarak3 into two new databases (tarak2 and tarak3) and then transfer the objects from tarak2 and tarak3 to tarak1 database with SSIS.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image
ThomasRushton answered
No - a backup is basically a block-by-block copy of a database. Restoring a database from a backup is, in effect, creating a copy of the original database as it was at that point in time. Your choices are, as @Magnus suggests, to either use a tool that provides object-level restores (eg Quest Software's Litespeed for SQL Server, or Red-Gate's SQL Backup), or to create two separate databases from the restore processes, and then transfer objects from one into the other. Additional: If it's just a one-off, then you can get a fully-functional trial licence of either of those products to do the job...
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Magnus Ahlkvist avatar image Magnus Ahlkvist commented ·
+1 for providing examples of products for object level restore.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.