We use cookies on our website to ensure we provide you with the best experience on our website. By using our website, you agree to the use of cookies for analytics and personalized content.This website uses cookies. More Information
It seems like your browser didn't download the required fonts. Please revise your security settings and try again.

Attention

Starting May 1st, 2018, we will no longer offer the ArchiveOne family of products. This includes all editions of ArchiveOne, ArchiveOne for Files, Max Compression, and Access Security Manager. If you currently hold a maintenance and support contract, you will continue to receive our award-winning support until your contract expires, or until May 1st, 2019, whichever occurs first. The license for ArchiveOne is perpetual; therefore the software may continue to be used independently without any updates or support indefinitely.

How to Resolve SQL Server Database Size Error

  • Last updated on

This article refers to the Barracuda ArchiveOne, and SQL Server Express and SQL Server 2008.

You can view the System Health report test summary by clicking System Health in the ArchiveOne Admin console. The summary displays the number of tests that succeeded, failed, or reported a warning. Double-click failures and warnings in the result row to review the full report. The SQL server database size test verifies the database size of your SQL Server. If you are running SQL Express, there is a 10GB size limit. Over an extended period of time, the C2CBrowseArchiveFolders database may reach this maximum size limit imposed by SQL Server Express. Once this limit is reached, no additional data can be added to the repository, and data will no longer fully synchronize. When this occurs, data may be missing when users view the C2CBrowseArchiveFolders database from the Search Archive website.

To resolve this issue, you have several options:

  • Flush and rebuild C2CBrowseArchiveFolders database – You may be able to free space by flushing the C2CBrowseArchiveFolders database and rebuilding it. However, this is dependent upon setting a retention period on your repositories to expire messages after a set period of time or if you delete messages. By flushing the database you remove messages that have been expired or deleted, therefore, the amount of freed up space is dependent upon the number of deleted or expired messages.
  • You can flush the Browse Archive database.
  • Move Database to a full version of SQL Server – If you cannot flush data from the database to keep it under the SQL Express maximum database size limit, you can move the database to a full version of SQL Server which has database size limit in terabytes. For more information, refer to the Microsoft article Move a database from one server to another server in SQL Server 2008.

    ArchiveOne can only point to one SQL instance, so in addition to the C2CBrowseArchiveFolders database you must move the other C2C SQL databases to the new SQL instance. See How to Change the SQL Server Instance for more information.

Last updated on