Summary
Microsoft SQL Server 2005 Express and Microsoft SQL Server 2008 Express contain a 4 GB database size limit. If the main database file for your Laserfiche repository reaches the size limit, you may receive an error 9008 and be unable to log in to your Laserfiche repository.
Resolution
Upgrade to Microsoft SQL Server 2008 R2 Express or the full version of Microsoft SQL Server. Microsoft SQL Server 2008 R2 Express increases the maximum database size to 10 GB.
Workaround
As a temporary workaround to allow a user to log in to the Laserfiche repository, you can try the following options.
Note: Stop the Laserfiche Server service prior to shrinking the database or truncating tables.
Option 1:
Manually shrink the database to release unused pages. You can manually use the DBCC SHRINKDATABASE statement or the DBCC SHRINKFILE statement to shrink a database or a specific database file. You can also choose to shrink a database using SQL Server Management Studio.
See the following Microsoft SQL Server 2005 documentation for more information on shrinking a database.
Option 2:
Manually clear out certain tables that contain temporary information. Use the TRUNCATE TABLE statement to remove all rows from a table.
Truncating the following tables may free up space:
See the following Microsoft SQL Server 2005 documentation for more information on the TRUNCATE TABLE statement.