Restore from a backup
tsm maintenance restore command to restore your Tableau Server data. You might do this if you had a system failure and need to restore your data, if you need to switch back to a previous version of Tableau Server (for example, if there is a problem with an upgrade), or if you are moving Tableau Server to new hardware. You can use the
tsm maintenance restore command to restore Tableau Server backups created using
tabadmin backup and
tsm maintenance backup. Database backups made in other ways, and virtual machine snapshots are not valid sources for restoring Tableau Server.
When you use
tsm maintenance restore to restore your Tableau data, the contents of the PostgreSQL database, and data extracts are overwritten with the content in the backup
.tsbak). If you are running a distributed installation of Tableau Server, perform the restore on the initial node or where ever the TSM Controller is running.
You can only restore from a backup that has the same type of identity store as the running server. For example, a backup from a server using local authentication can be restored to a Tableau Server initialized with local authentication, but a backup from a server using Active Directory authentication cannot be restored to a server initialized with local authentication.
Restore Tableau Server from a backup file
Note: This operation includes steps that must be performed with the TSM command line. You cannot complete this procedure using the TSM Web UI.
(Optional) Copy the
.tsbakfile to the default file location.
restorecommand expects a backup file in the directory defined in the TSM
basefilepath.backuprestorevariable. By default:
For more information about file paths and how to change them, see tsm File Paths.
Note: If you are restoring a backup that was copied into the backups folder, ensure that the Run As service account, which can be found in TSM Web UI under Security, has at least Read access to the backup file. Otherwise, the restore process may not be able to unzip the backup file and the restore will fail.
Stop the server. At a command prompt, type:
Restore from a backup file. At a command prompt, type:
tsm maintenance restore --file <file_name>
In the above line, replace
<file_name>with the name of the backup file you want to restore from.
Restart the server:
When you restore a
.tsbak file, Tableau Server automatically creates a copy of its current
data folder, names it
tabsvc.bak-*, and places it in
\data. This folder is an emergency backup of Tableau Server that Tableau Support may be able to use in case something goes wrong during backup restoration.
When the restore is complete and you have verified that Tableau Server is running correctly with all the expected data, it's safe to remove any
tabsvc.bak-* folders from
\data to free additional disk space. In Tableau Server clusters,
tabsvc.bak-* folders are created on each machine running Tableau Server.
Important: Only remove the
tabsvc.bak-* folders. Do not remove the
tabsvc folder, which is also located under
\data. It contains necessary Tableau Server data.