- 论坛徽章:
- 0
|
问题是我直接用sql语句执行可以备份,但用pymssql执行同样的语句却报错
backup database test1 to disk='c:\aa.bak'能成功备份
用pymssql执行
#!/usr/bin/env python
#coding=cp936
import pymssql
conn = pymssql.connect(host='192.168.40.155:1433',user='sa',password='123456',database='master')
cur = conn.cursor()
sql = "BACKUP DATABASE test1 TO DISK = 'c:\\aa.Bak'"
cur.execute(sql, ())
报错
Traceback (most recent call last):
File "D:\test\python\testmssqlbak.py", line 9, in <module>
cur.execute(sql, ())
File "D:\Program Files\Python25\Lib\site-packages\pymssql.py", line 185, in execute
raise OperationalError, e[0]
pymssql.OperationalError: SQL Server message 3021, severity 16, state 0, line 1:
不能在事务内部执行备份或还原操作。
SQL Server message 3013, severity 16, state 1, line 1:
BACKUP DATABASE 正在异常终止。 |
|