Select to view content in your preferred language

Auto Backup from ArcSDE

3099
4
06-15-2012 03:53 AM
CemUnustu
Deactivated User
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
0 Kudos
4 Replies
WilliamRice
Frequent Contributor
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.
0 Kudos
MudassarAshfaq
Deactivated User
dear can you share that python script , i will be highly thankful to you.
0 Kudos
VinceAngelo
Esri Esteemed Contributor
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
0 Kudos
VolkanTopaloglu
Deactivated User
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
0 Kudos