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 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.
Maintaining the ListManager MSDE 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.
We also recommend you perform 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.
More
1. Database Maintenance
1. MSDE Limits
3. Installing Service Pack 3a for MSDE