December 1, 2022 at 5:27 am
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.
December 1, 2022 at 1:21 pm
It isn't build in to restore selected tables. Perhaps with 3th party software?
I hope benefits / motiviation of consolidating all databases into one outweighs the hassles with recovery (recovery time ... )
December 1, 2022 at 1:30 pm
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.
December 1, 2022 at 1:48 pm
I hope your tenants don't have direct ( e.g. SSMS ) access to the database with mixed-tenant information in the objects.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
December 2, 2022 at 4:49 am
RLS and other tenant isolation will be in place. Thanks for the comment.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply