Sounds like you need columns for create_date, create_user, update_date and update_user. But of course you wont get the entire change history, which is what youre really looking for (ie....

Can you not break the update into smaller chunks?

Isaiah

Isolate the problem.

back up to disk, if it fails try another disk, then backup disk to tape. You have to get a valid backup asap.

Exercise care with the database recovery option. Its best to leave this to "Full" for all databases and make regular backups. Change to "Simple" or "bulk Logged" only...

Are the tables identical?

You'll want to address the cause of this growth. Its possible youre loading lots of data at a time. You can manage the growth of the transaction Log...

YES!!!!

I want to be able to programatically identify this kind of table. I can identify One-Many (easy) and One-One but many-many split to 2 One-Many seems to be challenging.

...

Ive just done something similar....

Your basic approace should not be a problem. The simplest way restore the databases is:

1) Take a backup of user databases to the disks that...