Database Maintenance and Administration

With the exception of MSDE (Windows), Lyris ListManager connects to and uses your database. Lyris Technologies does not provide technical support for installation, use or maintenance of PostgreSQL, MS SQL, or Oracle. Contact your database vendor for more information about support for these databases.

 

Backing up the database is the only maintenance you'll need to keep ListManager running smoothly. Backing up the database truncates the logs for MS SQL, which can fill your disk if left too long. You'll also want a backup of the database in case of a server failure. For more information about backing up your database, please consult your DBA or the appropriate documentation for your SQL database.

 

If you are running ListManager using the included MSDE database, we strongly recommend that you install Service Pack 3a to protect your database server

More

1. Database Maintenance

1. MSDE Limits

2. Backing Up MSDE

3. Installing Service Pack 3a for MSDE

4. Tuning PostgreSQL

 

 



Setting Server Options Connecting to Your Database with lmcfg.txt