This may be a question for MSSQL folks rather than Ignition folks, but thought I would give this a shot first. I am using MSSQL Express v.20.2.30.0 for logging 1 second historical tag data for trending. I have my database connected to Ignition and logging the data correctly. My issue is the database does not auto-grow even though the data file size is set to Unlimited and autogrowth is enabled. Once we hit the initial file size, all data points go into the store and forward and my gateway logs are flooded with “MemoryForwardTransaction - Unable to store data to quarantine.” Our initial file size is 10184MB, and I am able to store about 9 days worth of data within that file size. I am 99% sure I have all permissions correct, the user that Ignition is logging into SQL with IS the database owner as well. Any advice or ideas would be great, thanks!
That is very close to 10GB (close enough to just say it is 10GB) which is the file size limit for a DB in SQL Express. Consider switching to a more competent and full featured free database, such as PostgreSQL (Which has a max file size of > 100TB). While being free, there are several large companies that offer paid support, in case your organization is concerned about that.
3 Likes
That makes total sense and I feel like a dummy for not even thinking of that or finding that fact amongst all of my research. Thank you for this, I will send it up the chain!
Yeah SQL Express although free really isn't great option for production because of the size limitation. And logging points every second is a quick way to chew through that in a matter of days.
1 Like