SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 help moving data in database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jobimathew4
Starting Member

USA
8 Posts

Posted - 01/04/2013 :  14:30:09  Show Profile  Reply with Quote
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

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 01/04/2013 :  20:17:36  Show Profile  Reply with Quote
if you want just differences to be applied you can take differential backup and apply it to your copy so that all changes from last full backup gets applied

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000