Unity db log is full

[jupchur]

I have a unity db transaction log that has grown to 7Gig and is causing system errors. I have looked at several other systems and their log is under 3 meg. The settings on all the machines are set to grow the file automatically by 10%.

How can I backup or move this file to get the system working again? Also, is it ok to limit the size of the growth of this file or have circular logging enabled?

[lindborg]

The transaction logs are cleared when you do a backup using BackupExec or another Exchange aware backup package - if you're not doing regular backups (you really should be) then you really need to turn on circular logging or your files will continue to grow indefinitely.

this doc will be of interest - Cisco Unity Maintenance Guide (With Microsoft Exchange), Release 4.0(4)

http://www.cisco.com/en/US/products/sw/voicesw/ps2237/products_maintenance_guide_book09186a0080228417.html

You can also check out this white paper - Physical Storage Best practices:

http://www.cisco.com/univercd/cc/td/doc/product/voice/c_unity/whitpapr/storage.htm

And here's a white paper on moving thos transaction log to another drive:

http://www.cisco.com/en/US/partner/products/sw/voicesw/ps2237/products_tech_note09186a00800c6f5f.shtml

[bmanderville]

I do this everyday on all of my exchange servers, do I need to do it on the unity systems? They do not host the exchange databases. I have 4 Unity systems two of which have been UG to 4.0(4) and the others very shortly, one of which is an on box Exchange Server.

Thanks,

Bernie Manderville

[Hin Lee]

Open SQL Enterprise Manager

Drill down to UnityDb. Right-click on UnityDb and select Properties

Go to the OPTIONS-tab. Check Recovery->Model. If it is set to Full, change it to Simple. Click OK

Right-click on UnityDb. Select ALL TASK --> Shrink Database.

H. M.

[bmanderville]

Perfect,

I used the MS KB to actually shrink it earlier, but hopefully this will keep it from gorwing to the entire size of the disk.

Thanks Again,

Bernie Manderville

[jdiegmueller]

I just ran in to this same issue on a Unity 4.0(4) server, offbox storage. Because this is defined as a Unity "small" system, I used MSDE, and there there is was not an overabundance of disk space on C:. The UnityDb_log.ldf was 4331MB.

Shouldn't running a DiRT shrink this back down to size? I don't believe I've seen this behavior on any other Unity systems, previously.

-jd

[joveroc]

If you use the supplied exchange backup tool it will clear the logs after you back it up. I had this problem a few months ago and it worked fine. It takes just a few minutes.