Blog posts about Fax and Voice

As part of the default installation, RightFax installs SQL express. I support hundreds of RightFax environments and rarely do I see any problem with using SQL Express with RightFax. RightFax does not leverage the more advanced features of “regular” SQL so Express tends to fit the needs.

Until it doesn’t. Then you are screwed.

Afterhours, I got a ticket with the following information: (An error occurred while updating the entries. See the inner exception for the details. Could not allocate space for the object dbo.Audits. PK_Audits in database Rightfax because the PRIMARY filegroup is full”

Now for people that are unaware that RightFax uses SQL express, they would jump to the conclusion that the server ran out of disk space. This is not the case. The server ran into the SQL Express issue of the database cannot be larger than 10 GB.

The first thing I did was purge the Audits table as it is filled with login/logoff data which is not useful (until it is) and purging it will not impact performance of the server. I then shrank the database. This process got me 200 megs free which elevated the crisis but did not give me enough room to call it a day. I then tasked the overnight team to upgrade SQL Express to standard SQL which does not have a database limit. Its been over a week and issue is resolved.