Saturday, 4 July 2015

TableauServer Backup

Backup:-

A Tableau Server administrator should perform regular database maintenance, monitor disk
usage on the server, and clean up unnecessary files to free up space on the server. Taking
these steps can help ensure that Tableau Server runs with maximum efficiency.
You can use the tabadmin command line tool to back up and restore your Tableau data, and to
clean up (remove) unnecessary log and temporary files. 

Backup file contains Tableau data which includes Tableau Server's own PostgreSQL database, which stores workbook and user metadata, data extract (.tde) files, and server configuration data.

Step1:-
In the command prompt Enter,

     tabadmin backup <backupfile_location>
    
     For Example,
              Tabadmin backup aim_batch17.tsbak




 It will create a backup file in the bin directory of the tableau server,after backing up different server components.



 To append date to the backup file,add "-d" to the command and also specify the required location to store the backup file in a different location




Note:-
If we run the Backup command,it will automatically cleans all the log files which are older than 7 Days.

Thanks Guru's,
Prazval.ks

Count of A's in Each Customer’s Name

How many A's does each Customer have in their name(On Superstore Data)? Step 1: Create  3  calculated fields  “Cust Name Wi...