4 Replies Latest reply on May 13, 2014 8:13 AM by Toby Erkson

    Restoring a backup

    Kristian DiGaetano

      I am a fairly new server admin.  I have been asked to restore a backup and I followed the steps in the set up guide, but I don't think I fully understand what to do.  I stopped the server, but how to accomplish the next step (tabadmin restore <file>) eludes me.  When I pull up tabadmin a cmd prompt shows then auto disappears.  working in cmd prompt field I go to c:\program files\tableau\tableau server\8.1\bin then run the tab admin prompts.  Nothing seems to happen.  I then restarted the server, but there is no data.  I know that I am doing something wrong,yet I can't figure it out.  Any help would be appreciated.

       

      Thank you

       

      Kristian

        • 1. Re: Restoring a backup
          Toby Erkson

          Make sure you Run As Administrator when you open the cmd window.

          terkson - Tuesday, May 13, 2014 7_51_20 AM - Start menu.jpg

          • 2. Re: Restoring a backup
            Kristian DiGaetano

            Thank you.  I spoke with Jesse at Tableau and he walked me through the process.  I did not run as admin....

            • 3. Re: Restoring a backup
              Toby Erkson

              Typically the backup and restore are batch files you execute.  For example, here is my batch script I have when I need to perform a restore (Note: My server is on the D: drive and I use an UNDERSCORE between "Tableau" and "Server"...spaces bad!):

               

              @ECHO OFF
              REM  by Toby Erkson May2013
              REM  Input required:  Full file path and name are required.
              REM  Input example:  backup_restore "D:\Applications\Tableau\Tableau_Server\backups\backup_QA-2013-03-01.tsbak"
              
              IF EXIST %1 GOTO UsePath
              
              :NoPath
                  ECHO.
                  ECHO %1 not found.
                  ECHO Backup restore not done!
                  ECHO.
                  GOTO End
              
              :UsePath
                  ECHO.
                  ECHO  Please wait, admin password will need to be entered manually.
                  ECHO  Keystrokes will not dispay when entering password nor will cursor move.
                  ECHO  When done typing the password hit the 'Enter' key to input it and continue.
                  ECHO.
                  PAUSE
                  tabadmin stop
                  tabadmin restore %1
                  tabadmin start
                  SET /a EL=%ERRORLEVEL%
                  IF %EL% EQU 0 GOTO Restored
              
              :Unrestored
                  ECHO.
                  ECHO Backup restore failed!
                  ECHO Error number: %EL%
                  GOTO End
              
              :Restored
                  ECHO Backup restore successful.
              
              :End
              REM Add REMs to below 2 lines if automating.
              ECHO -- Pause --
              PAUSE
              EXIT


              Naturally, you would replace "D:\Applications\Tableau\Tableau_Server\backups\backup_QA-2013-03-01.tsbak" with the file and path of your backup .tsbak file.

              If you want to manually do it without a batch script then open a cmd window (as an Administrator ), make sure you are in the proper Tableau directory like you were before (C:\Program Files\Tableau\Tableau Server\8.1\bin ) and type in the following at the cmd prompt:

              tabadmin stop
              

              Hit the Enter key.

              tabadmin restore "your_filepath_and_filename_go_here"
              

              Hit the Enter key.

              tabadmin start
              

              Hit the Enter key.  When the cursor appears type in Exit, hit the Enter key, and you're done.

              • 4. Re: Restoring a backup
                Toby Erkson

                Glad you got it werkin'