an easy way to recreate the tables both on MSSQL, MySQL and local Cassandra is to restart the DMA, however the DMA needs to be active

so in your case, if it are for example trend tables you would need to switch and restart DataMiner then switch back and in the failover configuration box you can push the "old" data from a certain period of time

If those are tables data critical such as elementdata i would actually avoid any switching otherwise it's possible you overwrite data sensitive information

Then the only solution is to manually restore those tables, we have a MOP for MySQL but not for MSSQL:

Restoring a MySQL table structure or table data | DataMiner Docs