Tableau Server Backup and Restore

Creating a Backup

Step 1: Run as administrator

Click Start, and then select All Programs -> Accessories. Right-click Command Prompt, and select Run as administrator.

Step 2: Type the following command:

On a 32-bit machine:

cd “C:\Program Files\Tableau\Tableau Server\[version]\bin”

On a 64-bit machine:

cd “C:\Program Files (x86)\Tableau\Tableau Server\[version]\bin”

Note: Replace [version] with the version of Tableau Server you are running.

Step 3: Type the following commands:

tabadmin stop

tabadmin backup “H:\temp\[backupfilename.tsbak]” -d -t H:\temp

Note: Replace [backupfilename.tsbak] with the a name of your choosing. –d is to append date to backup fiename

Here we go, Backup is completed successfully. Check below details for recovery.

Creating a recovery from a backup

When you initiate a recovery from a backup file, you must stop Tableau Server and run the restoration. When the restoration process is complete, Tableau Server is started automatically.

For example, if you are restoring to the same machine:

tabadmin stop

tabadmin restore <backupfilename.tsbak>

Alternatively, if you are restoring to another machine:

tabadmin stop

tabadmin restore –no-config <backupfilename.tsbak>

When restoring from a backup, Tableau Server prompts for the password of the Run As account. You can provide the password in a script by creating a .txt file that contains only the password. Expanding on the previous example of restoring to another machine:

tabadmin restore –no-config <backupfilename.tsbak> <passwordfile.txt>

By default, Tableau Server looks in its bin folder for the password file. If you save the file in a different location, include the path to the file. For example:

tabadmin restore –no-config <backupfilename.tsbak>

<c:\location\passwordfile.txt>

Leave a comment