title: Azure SQL Server pyodbc backup
body: <p>I have on my azure portal 2 sql databases, which for demonstration purpose I call them <code>database one</code> and <code>database-two</code></p>
  <p>Using python ODBC Driver 17, I am able to connect to database one and create a simple table. So far no big issues.</p>
  <p>Where I am facing a problem, is when I try to make a backup of database-one I am getting this error:</p>
  <pre><code>pyodbc.ProgrammingError: ('42000', &quot;[42000] [Microsoft][ODBC Driver 17 for sql Server][SQL Server]Statment 'BACKUP DATABASE' is not supported in this version of SQL Server. (40510) (SQLExecDirectW)&quot;
  </code></pre>
  <p>the line of code I am using to achieve this is as follow:</p>
  <pre><code>cursor.execute(&quot;BACKUP DATABASE [database-one] TO DISK = N'./backup.bak'&quot;)
  
  </code></pre>
  <p>Is there any solution how I can run the backup from pyodbc?</p>