Welcome Guest, Login


Quick Search

Page History: Receiving Error: Could not allocate space for object 'cw_change_log' in database

Compare Page Revisions

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Sat, 17 Sep 2011 14:16

Source: jProgBusiness - Could not allocate space for object 'cw_change_log' in database 'CW_CHANGE_LOG_0008' because the 'PRIMARY' filegroup is full. INSERT INTO cw_change_log ( chn_lg_pk , chn_lg_table_name , chn_lg_pk_value , chn_lg_field_name , chn_lg_is_delete , chn_lg_new_value , chn_lg_usr_fk , chn_lg_dmn_fk , chn_lg_bt_version , chn_lg_date_time) VALUES (@chn_lg_pk , @chn_lg_table_name , @chn_lg_pk_value , @chn_lg_field_name , @chn_lg_is_delete , @chn_lg_new_value , @chn_lg_usr_fk , @chn_lg_dmn_fk , @chn_lg_bt_version , @chn_lg_date_time)

The error occurring is due to insufficient space on the hard drive where the database is installed or if using a SQL Server Express edition, the database has reached its maximum size limit. You can check both of these using the procedures below.

To find the amount of available hard drive space:

  1. Go to My Computer
  2. Right click on C: drive
  3. Select Properties
  4. The available hard drive space will be title Free Space

  • Note: If the SQL Server instance is installed on a different hard drive then the C: Drive, then you will need to complete the above steps on that drive letter to verify available hard drive space.

If the hard drive is out of space, then you will need to free up space. This can be done in a multitude of ways. The help desk suggests removing old backups first as this may be the cause of the reduced hard space. You may also want to remove unnecessary programs, clear caches, and so forth in order to create enough hard drive space. You can also move the SQL Server database to another hard drive if you are unable to free any space on the hard drive.

To find out the database size:

  1. Browse to the location of the database (Default location for SQL Server 2000: C:\Program Files\Microsoft SQL Server\MSSQL$CAREWare\Data)
    (Default location for SQL Server 2008: C:\Program Files (x86)\Microsoft SQL Server\MSSQL10CAREWare\MSSQL\DATA)
  2. Right click on CW_Data.MDF
  3. Select Properties

For SQL Server 2000: If the database size is close to 2 GBs then you will need to upgrade to SQL Server 2005 or 2008 Express or upgrade to a licensed version of SQL Server. For SQL Server 2008: If the database size is close to 8 GBs then you will need to upgrade to a licensed version of SQL Server.

If you do not know which version of SQL Server you are using, then you can log in to CAREWare and press Ctrl-I. This will bring up the System Information screen. The Data Tier Version will state the version number and in parenthesis the version type. If the version type is Express or Desktop Engine, then you have the free SQL Server instance installed.

Back to Frequently Asked Questions

jProg is a registered trademark of Jeff Murray's Programming Shop, Inc. All other products mentioned are registered trademarks or trademarks of their respective companies. Questions or problems regarding this web site should be directed to JeffMurray@jprog.com.

© 1998- Jeff Murray's Programming Shop, Inc. (jProg) , all rights reserved.