cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
222
Views
0
Helpful
1
Replies

Unity4.2 Issue/Report DataBase

muhannad
Level 1
Level 1

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

1 Reply 1

Tray Stoutmeyer
Cisco Employee
Cisco Employee

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

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: