Note

• Using the free Express edition of SQL Server can limit how large your database files can be. SQL Server Standard Edition has an upper limit of 524 Petabytes, but it is not free.
• If your database reaches the limit of your SQL Server Express version, you will begin to experience errors due to the inability of the database tables to accept new data.

The following is a list of SQL Server Express versions and their size limits:

• Microsoft SQL Server 2000 Desktop - 2 GB
• Microsoft SQL Server 2005 Express edition has a database size limit to 4GB
• Microsoft SQL Server 2008 Express edition has a database size limit to 4GB
• Microsoft SQL Server 2008 R2 Express edition has a database size limit to 10GB
• Microsoft SQL Server 2012 Express edition has a database size limit to 10GB
• Microsoft SQL Server 2014 Express edition has a database size limit to 10GB
• Microsoft SQL Server 2016 Express edition has a database size limit to 10GB

This guide will provide information on how to maintain the size of the database and avoid database limitation issues.

Process

1. Delete old scans manually or automatically: 
   1. To delete Manually
      1. Click the Configuration tab.
      2. Select Database Maintenance Options.
      3. Select Manage Scan Results. 
      4. Delete old and unneeded scans.
         
   2. To delete automatically:
      1. Click the Configuration tab. 
      2. Database Maintenance Options.
      3. Select Manage Retention Policy.
      4. Set the retention policy that fits your needs.
2. Clean up your Database. To clean-up your database, there are two options. 
   1. Option 1
      1. Go to Configuration > Database Maintenance Options > Manage Scan Results… and delete all scans.
      2. Go to Configuration > Database Maintenance Options > Database backend settings… And provide a new path and name for your new database. The new database is automatically created for you. For more information, you can refer to Creating a New SQL Database in GFI LanGuard.
   2. Option 2
      1. Go to Configuration.
      2. Database Maintenance Options.
      3. Click Database backend settings…
      4. Disconnect GFI LanGuard from the database you’ve backed up, and you want to delete, by connecting to another temporary database. You can create a new database by following Creating a New SQL Database in GFI LanGuard.
      5. Delete the database from the SQL Server using SQL Server Management Studio.
      6. Go to GFI LanGuard under Configuration > Database Maintenance Options > Database backend settings… and reconnect to the SQL Server.

Confirmation

Your database should regularly free up some space, and you should not be getting size limit errors.