Hi David,
Yes, this is possible. Below is an example using the PYODBC module:
import pyodbc
conn = pyodbc.connect('DRIVER={SQL Server};SERVER=<server name>;UID=sa;PWD=sa;Trusted_Connection=yes', autocommit=True)
backup_path = 'C:\\temp\\'
db = "VECTOR"
def backup_db(conn, db, backup_path):
cur = conn.cursor()
try:
cur.execute('BACKUP DATABASE ? TO DISK=?', [db, backup_path + db + r'.bak'])
while cur.nextset():
pass
cur.close()
except:
print 'Unable to backup: ' + db
backup_db(conn, db, backup_path)
conn.close()