<div>
The fastest solution is this:<br />
- Get all users out of Sage and open a command prompt window in the Sage database folder.<br />
- RENAME the file to a new name, say LOG_OLD.DAT:<br />
&nbsp; &nbsp; REN LOG.DAT LOG_OLD.DAT<br />
- Create a new file using BUTIL:<br />
&nbsp; &nbsp; BUTIL -CLONE LOG.DAT LOG_OLD.DAT<br />
- Allow users back into Sage.<br />
<br />
Note that you should use the right name of the log file, of course....
</div>


The fastest solution is this:
- Get all users out of Sage and open a command prompt window in the Sage database folder.
- RENAME the file to a new name, say LOG_OLD.DAT:
    REN LOG.DAT LOG_OLD.DAT
- Create a new file using BUTIL:
    BUTIL -CLONE LOG.DAT LOG_OLD.DAT
- Allow users back into Sage.

Note that you should use the right name of the log file, of course....

<div>
This question has nothing to do with SQL Server. &nbsp;You may want to consider posting in a more appropriate Topic Area, such as:<br />
<a href="https://www.experts-exchange.com/Database/Miscellaneous/" rel="ugc">https://www.experts-exchange.com/Database/Miscellaneous/</a>
</div>


This question has nothing to do with SQL Server.  You may want to consider posting in a more appropriate Topic Area, such as:
https://www.experts-exchange.com/Database/Miscellaneous/ [https://www.experts-exchange.com/Database/Miscellaneous/]

<div>
There used to be an area specific to Btrieve/PSQL, but EE eliminated it several years ago. Users now have to guess where to post, and often post to the SQL server or Postgres forums. Until a new forum comes around, I expect this mispostings to continue.
</div>


There used to be an area specific to Btrieve/PSQL, but EE eliminated it several years ago. Users now have to guess where to post, and often post to the SQL server or Postgres forums. Until a new forum comes around, I expect this mispostings to continue.

<div>
<div class="content wysiwyg-content">
I am working with sage accpac and the database is in pervasive 10.3<br />
I need to empty a LOG table that have history from 5 years now and is very big.<br />
I want to delete all records.<br />
How can I do it?
</div>
</div>


I am working with sage accpac and the database is in pervasive 10.3
I need to empty a LOG table that have history from 5 years now and is very big.
I want to delete all records.
How can I do it?

how to delete all records for a table in Pervasive?

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.