|
jobimathew4
Starting Member
USA
1 Posts |
 Posted - 01/04/2013 : 14:30:09
|
I am new to this forum and therefore not sure if this is the correct spot to post this question. If someone knows a different location or the problem resolved already let me know.
Currently we have an SQL server 2005 at a customer site that is actively collecting data. We use this data to create reports along with other analysis. I cannot access this data so I run a script that copies all the data between a given timeline and create a backup database then I have the customers send me the backup. I don't ask them to send me the whole backup since it gets too big and time consuming to move.
So over the past few months I have created a full backup with these partial backups by inserting data into the full database. This has been time consuming and inefficient as the log files just get huge and now I am left with log files to clean.
How do i get a partial database from the customer and create a full backup by appending to the existing full database. It would be great if the full database didn't have any duplicate rows. I have tried to use 'restore' without any success. It seems that will only works if the database backup was created partially in the first place. Let me know if any of it doesn't make sense and I will try better.
Jmathew |
|
help moving data in database
