Why cannot run "BACKUP DATABASE master TO DISK" in pyodbc?

[sailer shen]

I've connect to MS SQL server use pyodbc, when I run "backup database master to disk = 'd:\master_db.bak'", it shows:

Traceback (most recent call last):

  File "<stdin>", line 1, in <module>

pyodbc.ProgrammingError: ('42000', '[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]\xb2\xbb\xc4\xdc\xd4\xda\xca\xc2\xce\xf1\xc4\xda\xb2\xbf\xd6\xb4\xd0\xd0\xb1\xb8\xb7\xdd\xbb\xf2\xbb\xb9\xd4\xad\xb2\xd9\xd7\xf7\xa1\xa3 (3021) (SQLExecDirectW); [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE \xd5\xfd\xd4\xda\xd2\xec\xb3\xa3\xd6\xd5\xd6\xb9\xa1\xa3 (3013)')

How can I do it?

Thanks.

[brian...@gmail.com]

I can't do this either. Here's my latest attempt:

>>> cnxn = pyodbc.connect('DRIVER={FreeTDS};SERVER=%s;DATABASE=%s;UID=%s;PWD=%s' % ('srvr.domain','mydb','usr','pass'))

>>> cursor = cnxn.cursor()

>>> cursor.execute("""BACKUP DATABASE ? TO DISK = ? WITH FORMAT""",['mydb','C:\\folder\\backup'])

Traceback (most recent call last):

  File "<stdin>", line 1, in <module>

pyodbc.ProgrammingError: ('42000', "[42000] [FreeTDS][SQL Server]Incorrect syntax near 'mydb'. (102) (SQLExecDirectW)")

Thanks!