CSCeh01218 Bug

[applegreen]

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

[gpulos]

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)