GeoCue Server runs on top of a SQL database. The database stores all the metadata about your projects as well as all internal links to your geospatial data stored in the GeoCue warehouses. The database may be a full SQL database installation or a limited edition of SQL such as Microsoft SQL Server Express (Express) or Microsoft SQL Desktop Engine (MSDE). Express and MSDE are free versions of SQL limited to 5 concurrent users and a maximum database file size of 4 or 2 GB respectively. Note that it is very important to make sure regular GeoCue database backups are integrated with your standard IT backup and archiving policies. Failure to backup your GeoCue database on a regular basis can result in a significant loss of project data in the case of a hardware or software failure.
From time to time it may be necessary to backup your SQL database as part of your GeoCue backup procedures or when re-configuring (moving) or replacing your server hardware. This CueTip provides instruction on how to complete a GeoCue database backup as well as instructions on how to reconfigure (move) your GeoCue Server to new hardware.
Read the complete article: CueTip – Backing-Up the GeoCue Database and Reconfiguring the GeoCue Server
