cancel
Showing results for 
Search instead for 
Did you mean: 

BPASessionLog_NonUnicode

pavelzuravliov
Level 3
Hello, In DB table BPASessionLog_NonUnicode is the biggest one (7 GB) can we clean it up or just delete some data?
3 REPLIES 3

John__Carter
Staff
Staff
Sessions logs and queues normally account for most of the DB size, however I would not recommend deleting data via SQL because you might damage the DB. Use the Archive function in the BP client.

AMITJAGTAP1
Level 3
We are getting same issue as ""database size is full and need to delete some space for ""BPAsessionlog_nonunicode"""". We are deleting logs from BP client archiving function regularly. Is there any other resolution for this issues. Its hammering the data logs and reports. Previously we used to keep logs around 10 days but now within 4 days its throwing disk full massage. below is the actual massage: Number of rows of table [PRD_BP_DBTWO].[dbo].[BPASessionLog_NonUnicode] higher than 100000000 (436184847)

ryanamiller
Level 5
You can also go through processes and disable logging for steps in order to reduce the log sizes for each execution