How about .. have one db with log of events (cqrs style), the other one is transactional and transactions are being performed based on ordered events. When dep

How about .. have one db with log of events (cqrs style), the other one is transactional and transactions are being performed based on ordered events. When deploying new version - backup the transactional db and keep a pointer to the last event in events db. Keep the events db running. If restoring - restore transactional db backend based on backup and "play back" all events from the events db. The distinction can also be made using one db and backing up / restoring subset of the tables.