2 Replies Latest reply on Sep 27, 2012 6:47 AM by Thomas Cook

    Can I backup server without clearing log files?

    Thomas Cook

      I am looking for a way to backup Tableau Server without clearing log files that are more than 7 days old. I have a custom admin view that references the http_requests table of the internal DB.

       

      Doing a backup clears them out. I know I can save the old logs before doing a backup, but is there an easy way to restore them?

        • 1. Re: Can I backup server without clearing log files?
          Russell Christopher

          Hey Thomas!

           

          No, there really isn't a way to prevent http_requests from being trimmed. I've seen the folks who are interested in saving history "forever" develop three methods to save this info...this is not a complete list, of course - there are other techniques you could use:

           

          • Leverage an incremental extract to "import" these rows into Tableau
          • Use a SQL Server Integration Services package to move/copy rows from http_requests in postgres to SQL Server
          • Use Postgres SQL scripts to copy the http_requests table rows to a different database.

           

          In the latter two cases, you do all your reporting against SQL Server and/or the second postgres database vs. going after "our" workgroup database.

           

          Hope this helps.

          1 of 1 people found this helpful
          • 2. Re: Can I backup server without clearing log files?
            Thomas Cook

            I have already looked at doing an incremental refresh as my "Plan B" I guess I will have to roll with that.