We are trying to automate our tableau server restores so
that our backup server always has the latest backup restored to it and ready to
go.

We have the two scripts below which work fine when
manually executed while logged onto the server. The first script is a simple
windows batch file - as depicted in the tableau admin manual. This works fine
if we run it manually. However if we schedule it with the windows 2012 server
task scheduler, the job runs for a few seconds and completes as successful,
but the backup is not restored. There are no error messages. 

The 2nd script is a windows powershell script that also
run fine when manually executed while logged into the server. However, when we
schedule this to run with the windows 2012 server task scheduler, it runs but
never completes and stays in the windows task scheduler with a status of
"running" until it is manually cancelled. And the backup is not
restored.

We have tried to run the restores both as the tableau
run-as service account as well as trying it with a normal user id who is an
administrator on the server. Both have the same results.

Anyone else run into this issue or have any suggestions?

---------------------- 

BAT script  

tabadmin restore --no-config
E:\Tableau_backups\tableau_server_backup_nightly_restore.tsbak --password-file
"E:\Tableau_Maintenance_scripts\tableau_restore_password.txt"

powershell script         

Start-Process 'E:\Tableau\Tableau Server\9.0\bin\tabadmin.exe' "restore
--no-config E:\Tableau_backups\tableau_server_backup_nightly_restore.tsbak
--password-file E:\Tableau_Maintenance_scripts\tableau_restore_password.txt"