Our OLTP is being converted from a one tenant per database structure to a multi tenant DB. It was easy enough to use sql backups to restore point in time if one tenant destroyed they're data, but how can that be done when all tenants exist in the same tables? What are my options? The existing DBs range from 1 to 100GB so I expect several terabytes when they are consolidated.
Thanks Jo. The decision to move to multitenant was made by the IT business leaders rather than the DBA staff. The decision has merit, but the usual backup/restore methods can't be relied on. Im starting to think we'll need to "roll" our own custom solution for this scenario rather than rely on any 3rd party or other known fix.