Article ID: 311082
Article Last Modified on 2/19/2007
APPLIES TO
- Microsoft Content Management Server 2001 Enterprise Edition
- NCompass Resolution 4.0
This article was previously published under Q311082
SYMPTOMS
When you purge revisions in Content Management Server (CMS) 2001 from the Site Builder application, you may receive the following error message:
If you click Details for more information on the error, you may see the following:
The Microsoft SQL Server error log indicates that the log file for the database is full. The following is logged in the SQL Server error log file:
CAUSE
The transaction log for the SQL server is full.
RESOLUTION
To resolve this problem, back up the database or the transaction log to free some transaction log space.
WORKAROUND
To work around this problem, set the Automatically grow file property in SQL Server. This property provides the transaction log with the capability to expand as needed. You can govern the amount of growth, or set it to to use all available disk space.
MORE INFORMATION
Within the Site Builder, administrators can permanently delete all object revisions that were archived before a specific time. All revisions in the site that are older than the specified date and time are purged. To purge revisions, follow these steps:
- On the Tools menu, select Purge Revisions. The Purge Revision dialog box appears.
- Using the drop-down lists on the calendar, select the month, date, and time that correspond to the revisions that you want to purge.
- Click Purge. A confirmation message appears.
- Click Yes. All revisions before the date that you specified are purged.
REFERENCES
For additional information on why the SQL Server transaction logs become full, click the article number below to view the article in the Microsoft Knowledge Base:
110139 INF: Causes of SQL Transaction Log Filling Up
For more information, see the following Knowledge Base article:
310735 SQL Server Transaction Log Full When Importing an Object Package
For more information, see the "Page versioning" topic in the Content Management Server 2001 Help.
For more information, see the "Backup" topic in the SQL Server Books Online.
Additional query words: MSCMS, 7.0, 2000
Keywords: kbprb KB311082