Unity Issue/Report Database

Unanswered Question

Hi,


The transactional logs for the Unity report DB are increasing incredibly knowing that all generated reports have been completed (no queued reports).


It reaches 61 GB whereas report db (the actual DB) is 3MB only(Strange case).


Is there any non report related data which affects on the report db and its transactional log file?


what kind of jobs or data which may affect like this way ?


Also I have shrink this log file but unfortunatly it is being freed with 250MB only.


I appreciated your help.


Many Thanks,

Mo

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Rob Huffman Wed, 04/02/2008 - 06:28
User Badges:
  • Super Blue, 32500 points or more
  • Hall of Fame,

    Founding Member

  • Cisco Designated VIP,

    2017 IP Telephony, Unified Communications

Thanks Rob for your fast response.


the description for the warning event is as follows : "Autogrow of file 'ReportDb_log'in database 'ReportDb' took 123097 millisec. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file".



I have backed up the log file (64GB) and truncated twice a time, hence the physical size for the log file is decreased to 15 MB.


is this growing normal ? what do you think the cause for this ? I doubt it relates to generating report only.


what do you think ?


thanks Rob,

Mo

Actions

This Discussion