Unable to access voice mail box - Unified Messaging

[tony.hanson]

I have users here that cannot access there voice mail box. I've looked on the server and I'm finding that the UnityDb_log.LDF file has grown to more than 5 gig and there are running on low disk space. Can anyone tell me why the log file has grown so large and how I can get ride of it.

[Hin Lee]

Open Enterprise Manager, right-click on the database, select properties

Go to the Options tab and make sure that Simple Recovery is selected for Recovery Models.

If Full Recovery is selected, then it may not be possible to truncate the file.

Then right-click on the database again and select Shrink Database. Click on FILES button

Select the transactional log from DATABASE FILE, and select the option TRUNCATE FREE SPACE

FROM THE END OF THE FILE on the SHRINK ACTION choices. After shrinking, the Current Size

and Space Used should decrease significantly.

Be patient - open task manager to see that the process is still running.

Check the app logs for events around 2 am. There should be two events for SQLServerAgent. Post the errors so that we can figure out why your transactional logs grew to 5 gigs.

[tony.hanson]

That brought the file down to 504K. Now they can access there voice mail. I went into the event logs and did not see any logs for the SQLServerAgent, so I went to the Services and noticed that Service was not running, so I restarted it. I will monitor this and repost the results.

Thanks for the Super Fast Response, I'm still waiting for TAC to call me.