5 Replies Latest reply on Nov 25, 2016 4:47 AM by Jim Wilson

    We wish to run DB Cleanup job in our Environment to clean the old data.

    Amit Agaral

      We wish to run DB Cleanup job in our Environment to clean the old data.

      Where BSA 8.3 is running since last 5 years with SQL server 2008.
      While executing the job we have consider Retention Policy Days is 1800 days and execution mode is TYPICAL.

       

      But job has failed due to below error message,

      The transaction log for database 'bladelogic' is full.
      To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

                    
      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)

                    
      at
      com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)

       

      --> Our challenge is we can’t increase the space in hard drive, and we can’t move our mdf file to other location.