Help on the sql log error
xdai
Posts: 98
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
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
Comments
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.
Regards
Chris
Test Engineer
Red Gate