feat: ensure all meta store tables are empty prior to meta restore

### Is your feature request related to a problem? Please describe. _No response_ ### Describe the solution you'd like _No response_ ### Describe alternatives you've considered _No response_ ### Additional context _No response_