Database Maintenance and Administration
With the exception of MSDE (Windows), Lyris Aurea List Manager connects to and uses your database. Lyris Technologies does not provide technical support for installation, use or maintenance of 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 Aurea List Manager 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.
Maintaining the Aurea List Manager MSDE Database
If you are running Aurea List Manager using the included MSDE database, we strongly recommend that you install Service Pack 3a to protect your database server.
We also recommend youperform regular backups of the MSDE database.
Finally, if you have not implemented your own maintenance plan (using MS SQL client tools not included with MSDE),you should also enable the database maintenance scheduled task to perform maintenance tasks such as updating statistics and defragmenting the index.