topic Re: Automate ArcGIS Relational DataStore Backup in ArcGIS Enterprise Questions

Automate ArcGIS Relational DataStore Backup

AYUSHYADAV — Wed, 01 Sep 2021 06:39:11 GMT

Hi,

We have deployed ArcGIS Base enterprise version 10.8.1 in HA (high availability) on AWS. We have to take regular ArcGIS relational datastore backups on the Amazon S3 bucket.

As per the ESRI documentation, we can register a secondary backup location for tile cache and spatiotemporal datastores and set that secondary location as the default location for the backups.

And in the case of relational datastore, we register a secondary backup location but we can't set it as a default backup location, We can take only manual backups on the secondary backup location.

So, we have registered a secondary backup location for relational datastore on the amazon s3 bucket, and we want to take regular backups on amazon s3 itself. So, for that, I have created a batch file and scheduled it on the task scheduler.

My batch file looks like this:-

cd "C:\Program Files\ArcGIS\DataStore\tools"
backupdatastore --store relational --location type=s3;location=<s3 bucket name and location>;name=<datastore backup name>

I have checked and tested manually it works fine.

The main issue which I am facing after scheduling it on the task scheduler is that when we hit backupdatastore command it prompts for a question that "Do you want to continue Yes or No? "basically it wants user input after hitting backupdatastore command. And this is the point where the batch file fails or stops.

I just want to know is there any way we can automate the user input in the batch file.

Is there any better alternative way to automate relational datastore backups on amazon s3?

Any help will be much appreciated !!

Re: Automate ArcGIS Relational DataStore Backup

ChristopherPawlyszyn — Tue, 07 Sep 2021 13:06:29 GMT

You should be able to append '--prompt no' to your command and it will no longer ask whether to continue. The default backup location is required to be a file share for the relational data store, so there is no better built-in method to automate backups to S3 outside of a scheduled task/external script.

configurebackuplocation | ArcGIS Data Store command utility reference—ArcGIS Enterprise | Documentation for ArcGIS Enterprise
https://enterprise.arcgis.com/en/data-store/latest/install/windows/data-store-utility-reference.htm#ESRI_SECTION1_35FC910709804CC0AA43C44C5B15F810

Re: Automate ArcGIS Relational DataStore Backup

AYUSHYADAV — Tue, 07 Sep 2021 13:14:49 GMT

Hi Christopher,

Thanks for your reply. Yes you are right I was missing that --prompt no.