4 Replies Latest reply on Feb 26, 2015 10:14 AM by Matt Coles

    Tableau Server Backup

    rahul.pendyal

      Hi Community , we are soliciting some feed back on amount of storage needed on a primary server to be able to run backup and restore system if needed. Below is for server ver 8.3 .

       

      we looked at this article as well http://onlinehelp.tableausoftware.com/current/server/en-us/help.htm#distrib_requ.htm

      It states - "In addition to the amount of space needed for the backup file, you need temporary disk space roughly 10 times the size of the backup file (so if your backup is 4 GB, you should have about 40 GB of temporary disk space available)."


      In small install tests I have seen over 30% compression when a backup is ran.

       

      Here is the use case now  -> . In a distributed High availability env of (1) Primary (1) backup Primary (5) workers .Two (2) workers which run data engine and have the extracts have 10TB . Total storage used by tableau install across the servers is about 15 TB .

       

      How much storage will one need on the primary to run a successfully backup .

       

      Will one need 10 times of of 15 TB ( which is way!! tomuch) .

       

      thoughts ?Sudharshan SeerapuKiyoshi JonesJonathan Fritz

        • 1. Re: Tableau Server Backup
          Vien Hua

          Hey Rahul, 10-15 TB?? What is this computer?? Can we see some specs on them?

           

          Even if it takes just 15 TB to make a backup, I can imagine the backup taking ages and the restore process for that would be so long. Are you able to remove some unused extracts first? The server admin views will tell you which ones aren't active anymore. I'm sure there are lots mores issues with having a single 15 TB file too...

          • 2. Re: Tableau Server Backup
            rahul.pendyal

            Hi vien ,

             

             

            The machines are 8 cpu * 128 gb of mem.  The extracts in total are about 10tb not one big extract.   You are right old extracts could be removed .

             

            It's a multi tenant ( using sites ) architecture . 

             

             

             

             

             

            **Sent with mobile. Please excuse brevity & typos**

            • 3. Re: Tableau Server Backup
              Jonathan Fritz

              Hi Rahul - where are you calculating the 15 TB estimate? If it's based on your current server, we should look at your extracts themselves, perhaps we can optimize them to reduce the size requirement. As you note above, removing unused extracts will help. And, in general, Tableau compression rates improve over time.

               

              Of course, live connections eliminate the need for extracts altogether. It will be data-source dependent...but another option.

              • 4. Re: Tableau Server Backup
                Matt Coles

                If extract sizes are prohibitive, one of the most overlooked and space-reducing techniques I've found is to look for extracts being used locally in workbooks, and using the Hide Unused Fields feature to remove all fields that are not used in the workbook. This feature is a bit hidden, but in my experience has usually resulted in about an 80% to 90% reduction in size. It's an easy win because it doesn't entail changing the structure of the workbooks in any way, and there's really no defensible reason that a workbook published to Tableau Server should contain extract data that it does not make use of.

                 

                It would be great to have an automated way of identifying workbooks with this situation, and trigger alerts to the admin/users, but I don't have one yet.