The OPSROOT_Log.LDF file can grow very large (filling the hard drive) causing problems in Hach WIMS.  The problem occurs when the RECOVERY MODE is set to FULL for the OPSROOT database.  This happened in older versions of Hach WIMS and OPS SQL as those installs may have set the recovery mode incorrectly.  To Correct:

1. Get into Microsoft SQL Server Management Studio Express and log into the WIMS database.  See Note below if SQL Server Management Studio is not available.

2. Open the OPSROOT database, click New Query and paste in the following T-SQL commands and click Execute:

ALTER DATABASE OPSROOT
SET RECOVERY SIMPLE;
GO
DBCC SHRINKFILE(OPSROOT_Log, 1);

SQL Server will return results indicating the commands were executed:

The logfile should now be shrunk:

NOTE: The WIMS OPSROOT SQLCONSOLE (Admin Console, Action Scripts, Execute custom SQL commands against the OPSROOT database. Experienced users only! command) can be used to execute the T-SQL commands also (GO and ; NOT needed):

ALTER DATABASE OPSROOT
SET RECOVERY SIMPLE
DBCC SHRINKFILE(OPSROOT_Log, 1)