Accounts Production Advanced Support
Search
Search Accounts Production Advanced Support Help and Support.

This article applies to:

  • Product: Digita Accounts Production Advanced

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

note
If you're a Digita Virtual Office (DVO) user, then you will not be able to run scripts against your database. Contact the Support team to ask a member of the DVO team to run the script against your database.
  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.
    note
    This zip file contains
    DapaDBCleanup.exe
     and
    DatabaseCleanupScript.sql
  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.
note
You may get an "access denied" message when running the script. Right-click
DapaDBCleanup.exe
 and select "Run as Administrator". Make sure you have system administration privileges in SQL Server.