topic Re: Python to backup SDE database on Sqlserver Express? in Python Questions

Python to backup SDE database on Sqlserver Express?

DavidDoop — Wed, 09 Sep 2015 18:02:37 GMT

Is it possible to use Python to do a backup of SDE databases stored in Sqlserver Express? I have been using a custom executable that uses Arcobjects IDataServerManagerAdmin.BackupGeodatabase() but, I would prefer to use Python. The executable makes our IT staff a bit nervous.

thanks

Re: Python to backup SDE database on Sqlserver Express?

JakeSkinner — Sat, 11 Dec 2021 18:25:48 GMT

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()

Re: Python to backup SDE database on Sqlserver Express?

JoshuaBixby — Wed, 09 Sep 2015 21:34:58 GMT

If you haven't already, it might be worth checking out the Overview of copying geodatabases documentation, it covers a few different ways of getting data in bulk out of geodatabases. A note of caution, one of the links is incorrect and redirects you to another link. See the ArcGIS 10.2.x Help for Copying a geodatabase using the Copy tool.