>>> import pymssql
>>> con=pymssql.connect(host='.',user='netcafe',password='123456',database='mast
er')
>>> cur=con.cursor()
>>> cur.execute(r"backup database local to disk='d:\a.bak'")
Traceback (most recent call last):
File "", line 1, in
File "pymssql.pyx", line 465, in pymssql.Cursor.execute (pymssql.c:7190)
pymssql.OperationalError: (3021, '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')
>>>
使用pyodbc 会出现 backup无法在事务中执行的提示如下
>>> import pyodbc
>>> con=pyodbc.connect('DRIVER={SQL Server};SERVER=.;DATABASE=master;UID=netcafe
;PWD=123456')
>>> cur=con.cursor()
>>> cur.execute('r"backup database local to disk='d:\a.bak'")
File "", line 1
cur.execute('r"backup database local to disk='d:\a.bak'")
^
SyntaxError: invalid syntax
>>> cur.execute(r"backup database local to disk='d:\a.bak'")
Traceback (most recent call last):
File "", line 1, in
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) (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)')
使用 _mssql依旧出现和使用pymssql一样的提示
求助