Ok, this is a question borne purely from paranoia. But i want to ask all the same.
If I make changes to a db, and then apply a differential back up at a later date, what happens to the changes I have made?
So:
1: Take full back up.
2: Take diff.
3: Change data in the DB.
4: Apply diff to db.
EDIT:
Basically I'm copying a db, and I'm wondering if its quicker for me to reprocess some data, rather than wait for a diff. But if the diff arrives before the processing finishes, what would happen to the data I have reprocessed when the diff is applied.
EDIT 2:
The reason for wondering is that we are moving data centers. So i have one currently live environment, and am in the process of moving live to a new location. We have large DBs though that are taking days to move, and im wondering if i just re process the data (days of processing). If the diff arrives before the reprocessing is finished, i was wondering what the result of applying the diff would be (rollback to when the diff was taken?), or if we would have to restore both the full and then apply the diff, making reprocessing pointless.
(My gut tells me it will roll back to the when the diff was taken, but i want to really make sure this is right).
Cheers.