first_page

Random Screenshot: SQL Server Express Hitting the 4GB Limit

SQL Server Express Hitting the 4GB Limit

This one is a first for me. This error is in the form of:Could not allocate space for object 'TableName' in database 'DatabaseName' because the 'PRIMARY' filegroup is full. I don’t really expect to work with databases this huge—well within tens of millions of rows. But I thought it would be cute to import and analyze the IIS server logs of a couple of our W2-labor-camp machines and got in over my head.

  • First, there are two sets of logs on two boxes (behind one load balancer).
  • Second, these two different sets of logs are in two different IIS log formats!
  • Third for the three-month sample to analyze there are upwards of 20 gigs of text files to record.So I had to whip out the MSDN Universal Subscription and upgrade to SQL Server 2008 Developer Edition. It has been three days and I’m still loading records!

rasx()