有一个应用,需要实现sqlserver 2000备份和恢复,使用pymssql,和pyodbc均无法备份,请求帮助
pymssql代码及报错如下
>>> 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