The Lucity system is a significant investment of time and money for any organizations. To protect that investment you should regularly backup your system. Backing up your data, or setting up a backup plan is an IT responsibility and falls outside of Lucity Support. The goal of this article is to point out what should be backed up and give suggestions on how to do this.
The below suggestions might not be the best solution for your organization they are just meant as a starting point.
What to Backup
- Lucity Server Hive - The windows directory that stores all of the Lucity Config files, Report Hives, Document Hives, and License file. As these files are unique to your organization you should make a backup copy of them that you store elsewhere.
- Lucity VM Servers - If you are running your Lucity applications on virtual machines you should backup them up to save the applications and the configuration of that machine.
- Lucity Database - This is the backbone of the Lucity system. It contains all of your data as well as all configuration for the Lucity applications.
Database Backup Suggestions
- Create a Maintenance Plan for SQL Server to backup your database on a regular basis.
- Choose whether to use the Full or Simple recovery method.
- Don't directly backup the database's mdf and ldf files. Always create SQL Server backups. Back these up to a local drive then copy to an off-site storage area.
- Consider having the maintenance program Analyze, Index and Update Statistics for your database.
- Consider taking Full, Intermediate and Transaction Log backups.
- Consider encrypting backups (not available in SQL Express).
Suggested Database Backup Software
If you are using SQL Server Standard or Enterprise we suggest using the tools included with SQL Server.
If you are using SQL Server Express we suggest using SQL Backup Master which is an easy-to-use backup utility.