Help on the sql log error

xdaixdai Posts: 98
edited January 20, 2011 6:11PM in SQL Monitor Previous Versions
Hi WE got on 2.1 yesterday, and today i saw these errors:

Error: 1827, Severity: 16, State: 1.
2011-01-20 08:55:52.68 spid54 CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database.
2011-01-20 08:55:52.68 spid54 Error: 1105, Severity: 17, State: 2.
2011-01-20 08:55:52.68 spid54 Could not allocate space for object 'data.Cluster_SqlServer_SqlProcess_UnstableSamples'.'Cluster_SqlServer_SqlProcess_UnstableSamples_Id_CollectionDate' in database 'sqlmon' 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.
2011-01-20 08:55:57.21 spid54

what would the error mean? i have set to purge sql data to two weeks.

please help, thanks


  • Options
    i have found the answer, thanks
  • Options

    Are you using SQL Server Express Edition for the data repository by any chance? If you are then you will probably see errors like this quite often as some older versions are limited to 4GB per database.

    I believe that the SQL Server 2008 R2 Express allows up to 10GB of storage but even this would only hold a day or two of data.

    Chris Spencer
    Test Engineer
    Red Gate
Sign In or Register to comment.