backup-tableau-server-windows.bat

@echo off

# Create date-timestamp to use in backup-filenames
for /f "delims=" %%a in ('wmic OS Get localdatetime ^| find "."') do set DateTime=%%a
set Yr=%DateTime:~0,4%
set Mon=%DateTime:~4,2%
set Day=%DateTime:~6,2%
set Hr=%DateTime:~8,2%
set Min=%DateTime:~10,2%
set Sec=%DateTime:~12,2%

set Timestamp=%Yr%-%Mon%-%Day%__%Hr%-%Min%-%Sec%


# Archive Tableau Server log files
call tsm maintenance ziplogs -f tableaulog_%Timestamp%

# Backup data managed by Tableau Server (including repository, == workbooks, metadata, extracts )
call tsm maintenance backup -f tableaubackup_full_%Timestamp%

# Backup Topology and configuration data
call tsm settings export -f T:\backup\tableau\settings-%Timestamp%.json

# Deletes log files older than seven days, and temporary files.
call tsm maintenance cleanup