Note: This applies to Microsoft SQL Server 2005 and 2008.
To minimize the size of docushare_log file:
1. Use your standard backup procedure to back up the DocuShare Database.
2. Change the Recovery Model to Simple.
a. Highlight the database and select Properties. The Database Properties window will display.
b. From the Select a page window pane select Options.
c. From the drop down menu next to Recovery Model select Simple.
d. Click the OK button.
e. Right click the database and select New Query.
f. Type following Query command dbcc shrinkfile (',10) and select Execute button.
Where is replaced with the name of your Docushare database log backup file.
Example: dbcc shrinkfile ('Docushare_log',10)
g. Once the status of the query is listed as successful move to step 3.
Note: The status is normally displayed at the bottom of the page.
3. Change the Recovery Model back to Full.
a. Highlight the database and select Properties. The Database Properties window will display.
b. From the Select a page window pane select Options.
c. From the drop down menu next to Recovery Model select Full.
d. Click the OK button
4. Use your standard backup procedure to back up the DocuShare Database again.
Solution Published: May 22nd, 2013
Solution ID: 1313