
Business Central 15.0 OnPrem
the company was hit with Ransomware and have recovered the database, however, it does not include any keys. I cannot start the service due to missing keys and have been adding definitions from a demo database but am hoping there is a script I can run in TSQL that would rebuild from a data dictionary
Sorry to hear about this. A few ideas are out there if you're willing to try. Otherwise might be a good idea to contract with an experienced SQL DBA. Here's a few links that seem like they could have some potentially good ideas for you:
www.sqlservercentral.com/.../how-to-move-indexes-from-one-database-to-another-database
stackoverflow.com/.../programmatically-copy-indexes-from-one-table-to-another-in-sql-server