Unable to perform backup or restore operation in transaction

Question

I am using PyODBC to back up my database using the following code:

SQL_command = """
                BACKUP DATABASE [MyDatabase]
                TO DISK = N'D:\MSSQL\BACKUP\MyDatabase_20141212.bak' WITH
                      NOFORMAT
                ,     NOINIT
                ,     NAME = N'MyDatabase_20141212'
                ,     SKIP
                ,     REWIND
                ,     NOUNLOAD
                ,     STATS = 10
              """

conn.cursor.execute(SQL_command)

conn.cursor.commit()

An error message will appear in the above code:

pyodbc.ProgrammingError:

('42000', '[42000] [Microsoft] [ODBC SQL Server Driver] [SQL Server] Cannot perform a backup or restore operation as part of a transaction. (3021) (SQLExecDirectW);

[42000] [Microsoft] [ODBC SQL Server Driver] [SQL Server] BACKUP DATABASE ending abnormally. (3013) ")

I tried to run SQL code in SQL Server and it works fine.

Can I find out what is wrong with my code?

Many thanks.

Answer 1

.

pyodbc, ? autocommit:

conn.autocommit = true
// do stuff
conn.autocommit = false

pyodbc .

Answer 2

podbc .

- autocommit connect:

conn.autocommit = true