How to backup netsuite database ? I tried Skyvia but it has limited access to transaction tables

Use the Download data ? On Setup menu?

What's the navigation path to download data? Sorry, can't find it

I figured that may be what you meant. Was trying to find "Download data" phrase in the submenu.

my bad, was answering from my phone while on lunch. I have the common menus in my head some are less frequent AND i'm going to plead they moved it from Setup >> Company >> Netsuite Account Info.

Thank you for your time, but i was looking for more advanced solution, to backup restore and do sql queries

for SQL consider exploring Saved Search & SuiteAnalytics.

If you're looking for a paid service, you can try Stitch. In my experience, their data retrieval rate is too slow for my use case.

Thanks Mars, Stitch looks promising I will check it, hope it's enough for the client needs 😁

I'd suggest you focus on retrieving the transaction tables first and avoid list tables since data retrieval is relatively slow and you would have to review too many permissions if you try to get all list tables.