Article ID: 930424
Article Last Modified on 3/23/2007
APPLIES TO
- Microsoft SoftGrid for Terminal Services
- Microsoft SoftGrid for Windows Desktops
SYMPTOMS
When you administer applications from the SoftGrid Management Console, you receive the following error message:
Additionally, the following error message is logged in the SoftGrid Management Console log file (Sftmmc.log):
CAUSE
This problem occurs if one of the following conditions is true:
- The SoftGrid database transaction log reaches the maximum file size.
- The partition that contains the SoftGrid database transaction log is out of disk space.
By default, the SoftGrid database transaction log is configured to automatically grow to an unrestricted file size.
RESOLUTION
To resolve this problem, use one of the following methods.
Method 1
If the file growth is restricted and if the SoftGrid database transaction log reaches the maximum file size, follow these steps:
- Review the SoftGrid database transaction log settings. To do this, follow these steps:
- In Microsoft SQL Server, start SQL Server Enterprise Manager.
- Connect to the SoftGrid database server, expand Databases, and then expand SOFTRICITY.
- Right-click SOFTRICITY, and then click Properties.
- On the Transaction Log tab, note the following default settings:
- The Automatically grow file check box is selected.
- Under File growth, 10 is selected in the By percent box.
- Under Maximum file size, the Unrestricted file growth option is selected.
- Click Cancel, and then exit SQL Server Enterprise Manager.
- Modify the SoftGrid database transaction log settings, or reduce the SoftGrid database transaction log.
Method 2
If the hard disk partition that contains the SoftGrid database transaction log is out of disk space, follow these steps:
- Determine the location of the SoftGrid database transaction log. To do this, follow these steps:
- In Microsoft SQL Server, start SQL Server Enterprise Manager.
- Connect to the SoftGrid database server, expand Databases, and then expand SOFTRICITY.
- Right-click SOFTRICITY, and then click Properties.
- Click the Transaction Log tab.
- For the SOFTRICITY_Log row, note the value in the Location column.
- Click Cancel, and then exit SQL Server Enterprise Manager.
- Examine the location's partition for available disk space.
- Increase the disk space, or reduce the SoftGrid database transaction log.
For more information about how to reduce the SoftGrid database transaction log, click the following article number to view the article in the Microsoft Knowledge Base:
873235 How to stop the transaction log of a SQL Server database from growing unexpectedly
Keywords: kbtshoot kbexpertiseinter KB930424