none
SQL Express error licensed limit RRS feed

  • Question

  • Hello,

    We found some error during changing state of a compute node from online to offline. We found the following error in Event Viewer

    CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database.

    and

    Could not allocate space for object 'dbo.Changes'.'Changes_timestampIdx' in database 'HPCManagement' 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.

    This server was deployed with Windows 2008 Server HPC Edition + HPCPack 2008R2 3.4.4169.0

    How can we fix this?

    Monday, June 29, 2015 5:34 PM

All replies

  • You are running out of space as you are using SQL express version. To fixed issue, please try below:

    1. Upgrade your SQL express version to standard version which don't have 4G limit -- This has cost

    2. Try to clean up your DB

    3. Upgrade to SQL express 2012 or plus, as the database size limitation has grown to 10G limit, and this is still free of charge


    Qiufang Shi

    Tuesday, June 30, 2015 4:16 PM