I work on a team that customises software, part of this customisation is stored as records in a database, part is customisations to the schema itself and there are often some specific records in the database too.
I'd like to create a baseline version of the database and back it up normally. Then for each customer I restore the baseline database under the customer's name and customise it as usual. I'd then like to do a differential backup of the database from the baseline point to the current point and shelve the differential backup for that customer, I expect about 0.1-0.2% changed data. When I need to do more work for that customer I restore the baseline backup and their differential backup, do the work then backup again, replacing the shelved baseline backup.
This is similar to Differential databases (not backups) but using backups.
Can I have different differential backups that can be restored against a single baseline?
Can I do a new differential backup from the same starting point or would I need to do incremental backups.
Any problems or experiences with this sort of approach?