Database ldf file Is Growing Out Of Control
Issue
After a migration the .ldf file is growing out of control.
Reason / Possible Cause
If you are moving to a new DocuShare Server or install it is very important to verify that the older server’s data retention value matches the new server. If the default value is a higher number of days or infinite days on the old server and the new server does not have the same value DocuShare will start purging the access data that is older than 365 days when DocuShare is first starting up on the new server. Also, in addition to deleting access tracking data (which may be critical for some customers), it may result in database transaction log to get full and bog down DocuShare or fill the disk space.
Solution
Check the old config DSServerProperties.properties file to determine the old setting or verify via admin home, site management, access tracking. The new server must match this value.
1. Check the data retention values on the old server.
a. On the old server, browse to the following directory.
b. Open the DSServerProperties.properties file.
c. Check the following two values (make a note of the values)
o numberOfAccessDaysToKeep=365
o enableAccessDataCapture=true
d. Close the file.
2. On the new server, stop DocuShare.
3. Restore database from backup. (Since the .ldf has already grown out of control)
4. Browse to the \config directory.
5. Open the DSServerProperties.properties file in a text editor.
6. Search for the following two entries.
numberOfAccessDaysToKeep=xxx
enableAccessDataCapture=true
7. Edit the entries to match the values you found in the old config (Step 1c).
8. Save the changes.
9. Start DocuShare.
Solution Published: June 7th, 2014
Solution ID: 1511
Keywords: Database growing large