Database size close to limit

  • 2
  • Question
  • Updated 4 years ago
  • Answered

We have just received a warning telling us that our database size is getting close to the limit and that if we exceed the limit we risk losing our Front Desk data.

Has anyone else had this problem and can anyone offer a solution to this problem?

We run our software through the cloud and have recently converted to clinical notes so we are having to scan and store a lot more information online than previously.

Photo of Moreton All Body Care

Moreton All Body Care

  • 3 Posts
  • 0 Reply Likes

Posted 5 years ago

  • 2
Photo of Timothy

Timothy, Business Care Manager

  • 887 Posts
  • 267 Reply Likes
Official Response
This message is displayed to users whose Front Desk database size is approaching the limit set by Microsoft for different MS SQL database installations. This is not a common occurrence and generally only occurs if you have added attachments that have not been size optimised or added an exceeding large number of attachments to the database. 

Front Desk is designed to present this message to provide you sufficient time to resolve this issue, however please do not delay actioning this matter. 

As there a several options available to manage this, please open a support case at: 
Photo of Cath Gomboc

Cath Gomboc

  • 20 Posts
  • 7 Reply Likes
We upgraded our database to another size.  We are continuing to scan documents, and may run into this issue again at some point.  
Photo of Trevor


  • 70 Posts
  • 15 Reply Likes
What sort of size are we talking about? Wondering if we are anywhere near the limit.
Photo of Andrew

Andrew, Community Manager

  • 367 Posts
  • 114 Reply Likes
Hi Trevor

The limits can vary. If you would like to discuss your individual database set up and limits please open a support case for one of our staff to contact you:
Photo of Administration SUH

Administration SUH

  • 10 Posts
  • 0 Reply Likes
We also have been just started receiving this message and have been removing some of the larger attachments, as we have them saved in another file and optimizing our attachments. Will this automatically lessen our database size with Smartsoft? 
Photo of Andrew

Andrew, Community Manager

  • 367 Posts
  • 114 Reply Likes
Hi Tracey

Optimising images will certainly make them smaller (see below), and will automatically reduce the size of the file within the database. Removing unneeded attachments entirely will also reduce the database size.

That said, you would need to optimise or remove a significant amount of images to make any real impact. If you are receiving a message saying your Microsoft SQL database is reaching the limit, I would recommend opening a support case with our helpdesk so we can find the most appropriate solution: