MS SQL Server Express 2008 R2 Has 10GB Size Limit
UPDATE - 11/23/2010 -- LexisNexis does not support MS SQL Server 2008 R2 (paid or Express). It may be that Time Matters has no problems working on R2 and that LexisNexis has just not yet tested it. But there is some risk in moving to MS SQL Server 2008 R2 since at this writing it is not yet supported.
It is very important to take steps to avoid hitting 4GB database size limit if you are using MS SQL Server 2005 Express or an older release of MS SQL Server 2008 Express. If your Time Matters database hits that limit, you will not be able to add new records to Time Matters.
Time Matters 10 uses MS SQL Server as its underlying database software. The limit on the size of your Time Matters database when using Microsoft's free editions (2005 Express and 2008 Express) was 4GB.
MS SQL Server 2008 Express R2, released in April 2010, increases the database size limit to 10GB.
If your Time Matters database is approaching the 4GB limit of your existing MS SQL Server Express software, you have two options:
- Reduce the size of your Time Matters database by eliminating Attachment Bloat
- Upgrade to MS SQL Server 2008 Express R2 (not supported by LexisNexis yet) or to one of the paid versions of MS SQL Server 2005 or 2008 (2008 R2 not supported)
Installing MS SQL Server 2008 Express R2 is significantly more complicated than installing MS SQL Server 2005 Express. We recommend that you work with a LexisNexis Certified Independent Consultant or an experienced database technician to install 2008 Express and move your Time Matters database into this new software.
You can determine the size of your Time Matters database by looking at the size of a backup file, e.g., TimeMatters10AutomatedBackupTuesday.bak
For most small firms that are approaching the 4GB limit of MS SQL Server Express, Attachment Bloat accounts for more than 75% of the database size. Time Matters 9 SR3B and Time Matters 10 have a feature for moving Attachments out of the database and into the file system. In several cases of serious Attachment Bloat, we have assisted law firms in eliminating the problem.