We recommend the following with respect to backing up the SQL Database:
- A full backup prior to any service pack installs or version updates
- At minimum a weekly full backup of all databases (GeoCue and Federator)
- Daily Incremental backups (if possible)
Ideally one would want more frequent incremental backups since every transaction in GeoCue is stored in the database so the only way to truly know the state of the data is to have the most current version of the database, even hourly or midday incremental backups could be helpful.
Below are links to Microsoft articles that contain information concerning how to Create a Full Database Backup and How to schedule and automate backups within SQL.
Create a Full Database Backup (SQL Server)
How to schedule and automate backups of SQL Server databases in SQL Server Express
