Unity4.2 Issue/Report DataBase

Unanswered Question

Hi,

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

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

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

I appreciated your help.

Many Thanks,

Mo

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Tray Stoutmeyer Sun, 03/30/2008 - 08:22

I can't speak so much on what may have caused this. There might be a SQL job that is failing to truncate the logs. There is a way to fix these and shrink them manually. Should you need this, do the following in a command window.

How to shrink UnityDB/ReportDb if it grows too large:

1. Bring up command prompt

2. osql -E

3. use unitydb

4. go

5. backup log unitydb with no_log

6. go

7. dbcc shrinkdatabase(unitydb)

8. go

9. exit

To shrink the ReportDB, just do the same above commands and substitute ReportDB for UnityDb on all lines.

Tray

Actions

This Discussion