Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

Unity4.2 Issue/Report DataBase

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
Cisco Employee

Re: Unity4.2 Issue/Report DataBase

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

106
Views
0
Helpful
1
Replies