We already recommend creating a maintenance plan.
>Can your create maintenence plans for MSDE like you can with sql server? If so, part of a maintenence plan allows you to reorganize the data and index pages, which is something I would suggest doing in addition to the db and transaction log backups.
>
>>We're in the process of generating documentation for our SQL Server customers. We need to discuss maintenance issues. Some people will be using MSDE without a System Admin. What advice, other than "Do backups" could we give them?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer