cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
iceraider_12
Engaged Sweeper
The error logs on our server are filling up frequently. We are seeing the following messages over and over again:

2010-09-08 18:37:38.64 spid53 Error: 1827, Severity: 16, State: 1.
2010-09-08 18:37:38.64 spid53 CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database.
2010-09-08 18:37:38.71 spid53 Error: 1105, Severity: 17, State: 2.
2010-09-08 18:37:38.71 spid53 Could not allocate space for object 'dbo.tblerrors'.'PK__TsysErrors__408F9238' in database 'lansweeperdb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

We have free space on our server so I don't think it's a space issue. I know SQL express has a 4GB limit. Can we upgrade to regular SQL to get past this limit? Also, what could be trying to use so much space in our database. We're pretty much configured with the default settings although we did configure a custom file search for a specific application that we're looking for.
3 REPLIES 3
Hemoco
Lansweeper Alumni
I suggest upgrading to SQL workgroup version, this version don't has the database limit.
iceraider_12
Engaged Sweeper
We have about 3000 computers on our network. No, that's not a typo, 3000.
Hemoco
Lansweeper Alumni
If you are using SQL express you need to upgrade to another SQL version to bypass the 4GB limit.

How many computers are you scanning?