Cannot perform a backup or restore operation on a transaction
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 7.000000000000001%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGC%3C/text%3E%3C/svg%3E)
Gian Consiglio
21
Reputation points
Hello everyone, I have a problem with an algorithm I developed in Python. Basically it sends a query to the sql server that should backup a particular database, but every time I run it, it returns this error:
('42000', '[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot perform a backup or restore operation on a transaction. (3021) (SQLExecDirectW); [42000] [Microsoft ][ODBC Driver 17 for SQL Server][SQL Server]BACKUP DATABASE is terminating abnormally. (3013)')
With other queries it works normally, except to perform backups or restores. Does anyone know if there is any way around this?
SQL Server | Other
Answer accepted by question author
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)