title: how to use TSQL syntax to restore .bak to new db?
body: <p>I know that there are many similar questions in stackoverflow, but non of them totally satisfied my request?</p>
  
  <blockquote>
    <p>1 - I DO NOT WANT TO ATTACH A DATABASE that contains 2 .mdf .ldf files<br>
    2 - The file is only a single .bak file<br>
    3 - i don`t want to use Microsoft SQL Management.<br>
    4 - i need it to be done programmatically ?( in my case c#) <br></p>
  </blockquote>