[cisco-voip] Unity 4.0(4) - Unitydb.LDF files growing

[Carter, Bill]

I got this fixed.  The "sql nightly..." and "sql weekly backup..." jobs
were failing with the message "SQL unable to determine if user
domain\unityinstall has sufficient rights.."  The Unity accounts were
not under SQL logins.  I added the accounts to logins and duplicated the
SQL settings from another Unity system not experiencing these problems.
This still did not work.

In the end I added the local administrator account to the SQL logins and
configured the SQL jobs to use this account with success.

This is a UM environment and the partner server is Windows 2003/
Exchange 2003.  The one caveat I suspect is the W2k3 server OS is
actually W2k3 Small Business Edition.  Don't know if this matters. 

-----Original Message-----
From: Wes Sisk [mailto:wsisk at cisco.com] 
Sent: Thursday, July 28, 2005 1:18 PM
To: Carter, Bill; cisco-voip at puck.nether.net
Subject: RE: [cisco-voip] Unity 4.0(4) - Unitydb.LDF files growing

There should be a scheduled sql job to do this nightly backup or weekly
backup or something like that. "sql nightly backup job" and "sql weekly
backup job"

/Wes

-----Original Message-----
From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net]On Behalf Of Carter, Bill
Sent: Thursday, July 28, 2005 1:46 PM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] Unity 4.0(4) - Unitydb.LDF files growing


I have a customer experiencing the problem of the Unitydb.ldf files
growing until they consume all available space on the hard drive.  When
necessary, they manually truncated the files using the OSQL -E
procedures.

The latest version of Dirt backup is run every night.  I have gone into
SQL Enterprise Manager and created a maintenance plan to backup, but it
doesn't.  If I created the plan, click OK exit the Plan, and go back
into the plan, all of the settings are lost.

What will it take to get the LDF files from growing?  Can I write a
script or batch file to run the OSQL -E procedures?  Do I need to
re-install Unity?

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip