Database

Run the Database Cleanup in Accounts Production Advanced

You can run the Database Cleanup to improve efficiency. It will remove redundant data that builds up as a result of creating new periods, template editing, and other use. All users need to be out of the software when it's run and it may take a while, so it's a good idea to run the database cleanup overnight.
You can run Database Cleanup from Accounts Production Advanced, on the server with a script, or in SQL Management Studio.

From Accounts Production Advanced

  1. Open Accounts Production Advanced and select
    Tools
     then
    Database Cleanup
    .
  2. You should run this daily, before upgrading the application, or before checking out client data.

On the server with a script

  1. In the downloaded Suite, open
    \Content\DAPA\Script\.
  2. Run the
    DapaDBCleanup.exe
     file on the primary computer.
Alternatively you can download DapaDBCleanup.exe and an SQL script. You can run the SQL script in SQL Server Management Studio.
  1. Download our Database Cleanup Script ZIP file.
  2. Sign in to the server.
  3. Run
    DapaDBCleanup.exe
     from the folder you extracted the ZIP file to.

Automated nightly process

We recommend scheduling the cleanup using a nightly process. If you have SQL Server Standard, a maintenance plan can be set to run using the SQL file from the
\Content\DAPA\Script\
 folder. You can also follow the steps in our help topic: Schedule database clean up and re-indexing on Accounts Production Advanced.
Alternatively, from the same folder, the
DapaDBCleanup.exe
could be scheduled using the Windows Task Scheduler. The Windows account used for authentication must have SQL Server 'sysadmin' privileges. These would both need setting up directly on the SQL Server.

This article applies to:

  • Product: Digita Accounts Production Advanced