python读取sqlserver数据库备份文件_python怎样实现sqlserver备份?报错问答阿里云开发者社区阿里云...

有一个应用&＃xff0c;需要实现sqlserver 2000备份和恢复&＃xff0c;使用pymssql,和pyodbc均无法备份&＃xff0c;请求帮助

pymssql代码及报错如下

>>> import pymssql >>> con&＃61;pymssql.connect(host&＃61;&＃39;.&＃39;,user&＃61;&＃39;netcafe&＃39;,password&＃61;&＃39;123456&＃39;,database&＃61;&＃39;mast er&＃39;) >>> cur&＃61;con.cursor() >>> cur.execute(r"backup database local to disk&＃61;&＃39;d:\a.bak&＃39;") Traceback (most recent call last): File "", line 1, in File "pymssql.pyx", line 465, in pymssql.Cursor.execute (pymssql.c:7190) pymssql.OperationalError: (3021, &＃39;Cannot perform a backup or restore operation w ithin a transaction.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n&＃39;) >>>

使用pyodbc 会出现 backup无法在事务中执行的提示如下

>>> import pyodbc

>>> con&＃61;pyodbc.connect(&＃39;DRIVER&＃61;{SQL Server};SERVER&＃61;.;DATABASE&＃61;master;UID&＃61;netcafe

;PWD&＃61;123456&＃39;)

>>> cur&＃61;con.cursor()

>>> cur.execute(&＃39;r"backup database local to disk&＃61;&＃39;d:\a.bak&＃39;")

File "", line 1

cur.execute(&＃39;r"backup database local to disk&＃61;&＃39;d:\a.bak&＃39;")

^

SyntaxError: invalid syntax

>>> cur.execute(r"backup database local to disk&＃61;&＃39;d:\a.bak&＃39;")

Traceback (most recent call last):

File "", line 1, in

pyodbc.ProgrammingError: (&＃39;42000&＃39;, &＃39;[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) (SQLE

xecDirectW); [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATAB

ASE \xb2\xd9\xd7\xf7\xd2\xec\xb3\xa3\xd6\xd5\xd6\xb9\xa1\xa3 (3013)&＃39;)

使用 _mssql依旧出现和使用pymssql一样的提示

求助