May 28, 2010 · Truncate logs in SQL Server 2008, is to switch the database to Simple Recovery Mode (ALTABASE DBNAME SET Recovery SIMPLE), resets the database back to the original recovery mode (ALTER DATABASE DBNAME SET Recovery Full). If a log backup is not required, you can set the database directly to Simple recovery mode.. Dec 29, 2020 · def transaction_logs(logs, threshold): count = Counter() for log in logs: for usr in set(log.split()[:-1]): count[usr] += 1 res = [] for k, v in count.items(): if v >= threshold: res.append(k) return res print (transaction_logs(['345366 89921 45', '029323 38239 23', '38239 345366 15', '029323 38239 77', '345366 38239 23', '029323 345366 13', '38239 38239 23'], 3)).