Database Maintenance

To view details of the NewsMan Pro database, click on the Tools menu and select the Database Maintenance option.



A window will appear giving you an overview of the database.



Clicking the Properties button will allow you to change the database engine you are using as well as change the login name and password used to connect to the database (you must change the actual database login and password using the administration tools provided by the database).


The database maintenance window allows you to perform maintenance and repair operations on the database.



Optimize
This procedure should be run periodically. It defragments and shrinks the storage space required by the database by removing deleted data. In addition, indexes are rebuilt and any database errors are reported. Generally, whenever you feel that NewsMan Pro is starting to run slowly, try optimizing your database, particularly after deleting and purging many messages. The first step of the optimize process is a "Database Sweep". The sweep removes database records that are no longer required from your database. You can skip the sweep if you have run it recently and simply want to optimize the database itself.

Repair
If NewsMan Pro reports a database error, run this procedure to attempt repairs. You can prevent most errors from occurring by following a few simple rules:

• Never shutdown your computer while NewsMan Pro is running
• Allow NewsMan Pro to shutdown gracefully whenever possible

Please note that there are no optimize/repair facilities built-in to Newsman Pro for MSSQL databases. You should use Enterprise Manager or SQL Server Management Studio to create a Maintenance Plan that will periodically keep your database in good working order.


While database corruption that is irreparable is very rare, it can happen. Please contact us for help in recovering your database, or you can create a fresh database by doing one of the following:

Advantage Database users
The ADS database will be stored in one of two locations:

1. <LocalAppData>\Newsman Pro\Data
2. <Program Files>\Newsman Pro\Data

Windows Vista has introduced a new location for <LocalAppData>:

• users\<user>\AppData\Local\Newsman Pro\Data

Navigate to the appropriate location for the “Data” folder and move it elsewhere, rename or delete it. Restart NewsMan Pro and the database will be recreated.


MySQL users
When starting NewsMan Pro, change the catalog name to create a new database using a different name. Alternatively, use MySQL Administrator to drop the old database and Newsman will prompt you to create a new database the next time you restart. If you have disabled the login prompt, you must delete the file database.ini and restart NMP to change the catalog name.


MSSQL users
When starting NewsMan Pro, change the catalog name to create a new database using a different name. Alternatively, use Enterprise Manager or SQL Server Management Studio to drop the old database and Newsman will prompt you to create a new database the next time you restart. If you have disabled the login prompt, you must delete the file database.ini and restart NMP to change the catalog name.