Append .bak (Backup) file to Database using Restore command

[sachinkale123]

Hi,
I have 2 database having same tables but different data. I have backup of 1st table. With restore command when i try to restore 1st databse to 2nd databse it overwrites the record from 2nd database.

1) Is there any 'other restore' command with which i can restore 1st database to 2nd.
2) If not then is there any command to copy 1st database to 2nd database.
(Both have same tables but different data).

Please help me i m searching this for last 2 days...

Thanx

[ck9663]

Hi,
I have 2 database having same tables but different data. I have backup of 1st table. With restore command when i try to restore 1st databse to 2nd databse it overwrites the record from 2nd database.

1) Is there any 'other restore' command with which i can restore 1st database to 2nd.
2) If not then is there any command to copy 1st database to 2nd database.
(Both have same tables but different data).

Please help me i m searching this for last 2 days...

Thanx

1. There's a way. Remove REPLACE. Check the full RESTORE syntax here. And check the argument and keywords here .

2. If it's in the same network, yes. Link the server and transfer the data through DTS or query.

Good luck.

-- CK