topic Re: Auto Backup from ArcSDE in Data Management Questions

Auto Backup from ArcSDE

CemUnustu — Fri, 15 Jun 2012 10:53:25 GMT

Could anyone help me about take an auto backup of database from ArcSDE geodatabase to file or personel geodatabases at the localhost ?

Best Regards,

Cem UNUSTU
Hydrogeological Engineer

Re: Auto Backup from ArcSDE

WilliamRice — Sun, 17 Jun 2012 16:34:46 GMT

Our organization has field staff who use ArcGIS Desktop on Laptops. So, we have a need for exporting feature classes out of our ArcSDE Geodatabase on a nightly basis to personal and/or file geodatabases. I have written a Python script that uses the ArcGIS geoprocessing arcpy.Copy_Management commands to copy all the feature classes under a feature dataset to the personal or file geodatabase. I then run the script as a scheduled job on our server to export the data every morning. Other geoprocessing commands can be used to copy individual feature classes or standalone tables or to create Address Locators in the file based geodatabases. Other Python commands will need to be used to make copies of previous exports or make copies of empty personal or file geodatabases to contain the new morning export.

If you need to just a backup of an individual ArcSDE feature class, you could also use the ArcSDE administration command "sdeexport -o create" and create a scheduled job using a DOS batch file containing these commands.

Re: Auto Backup from ArcSDE

MudassarAshfaq — Sat, 12 Jan 2013 03:46:18 GMT

dear can you share that python script , i will be highly thankful to you.

Re: Auto Backup from ArcSDE

VinceAngelo — Sun, 13 Jan 2013 16:39:29 GMT

The only reliable way to make backups of versioned ArcSDE geodatabases is through
database tools. Copying the SDE.DEFAULT (or any other) version to file geodatabase
(or any other export format) will not capture any other branch in the version tree.
ArcSDE export format will not capture tables which are edited together (feature
datasets) at the same moment in time, and won't be cognizent of domains or other
geodatabase functionality during restore.

Even with database tools, you must be certain to capture all tables at the same
moment, including the SDE user metadata, and if you intend to repair just one
versioned table with the backup, you need to be prepared for some difficult work.

- V

Re: Auto Backup from ArcSDE

VolkanTopaloglu — Tue, 25 Jun 2013 12:22:47 GMT

Could anyone help me about take an auto backup of database from ArcSDE geodatabase to file or personel geodatabases at the localhost ?

Best Regards,

Cem UNUSTU
Hydrogeological Engineer

. xml file in this directory and then introduce a fixed python command to the database as the server can nominate as a scheduled task. However, the scheduled time due to the structure of the XML file to your backup before you need to take your own. Cem tool'u verdi mi eleman...

Volkan Topalo�?lu
Geographer