How to get erpnext database as .mdf to restore it on sql server

I want a copy from the database to restore it to SQL server and create sql query report from that

First, why can you not connect your report creation direct to the Mariadb/mysql database?

If you really insist, you will need to export. if you use a tool like PhpMysql you can export to various formats, including mssql.

i have a backup from my test server and try to restore it to ssms and it only accept mdf file not sql

Could you give me steps plz

Google is your friend - this howto may be what you are after?

Please share the steps with perhaps some screenshot pointers from what you learn thanks