Unity Issue/Report Database

[muhannad]

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

[Rob Huffman]

Hi Mo,

It sounds like your new logs are not overwriting your existing files.

Good info from Jorge, Ginger and others;

http://forum.cisco.com/eforum/servlet/NetProf?page=netprof&forum=Unified%20Communications%20and%20Video&topic=Unified%20Communications%20Applications&CommCmd=MB%3Fcmd%3Ddisplay_location%26location%3D.1ddd23e1

Good info from Unity Master Jeff;

http://forum.cisco.com/eforum/servlet/NetProf?page=netprof&forum=Unified%20Communications%20and%20Video&topic=Unified%20Communications%20Applications&CommCmd=MB%3Fcmd%3Dpass_through%26location%3Doutline%40%5E1%40%40.1dd6333a/0#selected_message

Hope this helps!

Rob

[muhannad]

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