A standard RFP question for SaaS should be:
- Can you restore data for a single customer, and if so, what is the RTO for that operation?
A smaller SaaS could be excused for only thinking about full database restores. When you're a scrappy upstart, thinking about hypotheticals is less important than survival.
But for any decent size multi-tenanted SaaS, it's imperative that you have the ability to selectively restore individual customers.
The usual approach is to do a full database restore into a separate instance, then run your pre-prepared "restore customer" scripts to extract a single customer's data from there and pump it across your prod instance. In Oracle for example you might use database links to give your restore code access to prod and also the restore instance at the same time.
Atlassian - MUST DO BETTER.