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

CSCeh01218 Bug

Hi, I run into CSCeh01218 Bug this morning,http://www.cisco.com/cgi-bin/Support/Bugtool/onebug.pl?bugid=CSCeh01218, I followed the workaround from this BUG tool, this bug is offically fixed in Version 4.1,my systme is running 4.05. it is a standalone voicemail box

I followed every step in the BUG tool

Ensure the Unitydb database properties have "Auto Shrink" unchecked and

the Recovery Mode option set to "Full" on the "Options" tab.

Verify the Reportdb database properties have " Auto Shrink" unchecked and

the Recovery Mode option set to "Simple" on the "Options" tab.

If the SQL Job Agent History displays the following error:

SQLSERVERAGENT 208 SQL Server Scheduled Job 'SqlNightlyBackupJob'

(0xDD76B87067B64E4EA8BE7C8EE0B05F59) - Status: Failed -

Invoked on: YYYY-MM-DD HH:MM:SS - Message: The job failed. The Job was invoked

by Schedule 8 (Nightly UnityDb Backup Schedule). The last step to run was step 2 (BackupUnityDbLog).

...then see the Release Note and workaround for CSCsa95341.

The following steps will truncate the logfile once.

The condition that created the large logfiles WILL still exist.

These commands should ONLY be run _after_ following the steps above.

Open a CMD line and enter the following:

osql -E

1> use unitydb

2> go

1> backup log unitydb with no_log

2> go

1> dbcc shrinkdatabase(unitydb)

2> go

1>exit

my question is

is this a one time fix and it will happen again or it got fixed permantly ? thank you in advance

1 REPLY
Blue

Re: CSCeh01218 Bug

YES,

this problem will occur again. you cannot keep the SQL DB from growing so all you can do is to perform maintenance as you've done with the OSQL shrinkdatabase command.

i've had limited success with the osql shrinkdatabase command as the DB only stays shrunk until it increases again.

(in my case by the next day with so much data; i don't have the problem on unity but another SQL DB such as CDR)

129
Views
0
Helpful
1
Replies