Backup & Recovery

Protect your data with one-click backups, automatic safety copies, and full project exports. This guide covers both SQLite (solo) and SQL Server (team) scenarios.

One-Click Backup Database

The fastest way to create a backup is from the File menu:

Go to File > Backup Database — or use the Command Palette (Ctrl+K) and type "Backup".
Choose a location — Select where to save the backup file.
Backup completes instantly — For SQLite projects, GlyphFex copies the .glyphfex file and its attachments folder. For SQL Server projects, GlyphFex runs a BACKUP DATABASE command.

What gets backed up

Project Type	Backup Contents	File Format
SQLite (Solo)	Database file + attachments folder	`.glyphfex` copy
SQL Server (Team)	Full database via BACKUP DATABASE	`.bak` file

Tip Schedule a weekly backup as part of your routine. For SQL Server, consider setting up a SQL Server Agent job to automate nightly backups.

Automatic Safety Backups

GlyphFex automatically creates a timestamped .bak safety copy before certain operations that could modify your data:

Before migration — When migrating from SQLite to SQL Server, a backup of the destination database is created if it contains existing data.
Before project reset — When resetting project settings, a timestamped backup file is created first.

These safety copies are saved alongside the original file with a timestamp suffix, such as MyProject_2026-03-22_143000.bak.

Note Automatic backups are a safety net, not a replacement for regular manual backups. Always maintain your own backup routine for critical production data.

Save As (Project Copy)

Use File > Save As (Ctrl+Shift+S) to create a complete copy of your project under a new name or location.

Creates a full duplicate of the .glyphfex database file
The new copy is independent — changes to one do not affect the other
Useful for creating snapshots before major configuration changes
Also useful for creating template projects that you clone for new customers or job types

Tip Save As is the simplest way to create a point-in-time snapshot of a solo project. Before making major changes to your pipeline or categories, do a quick Save As to preserve the current state.

SQL Server Backup

For shared (team) projects running on SQL Server Express, GlyphFex uses the native BACKUP DATABASE command:

From GlyphFex

Use File > Backup Database while connected to a SQL Server project. GlyphFex will prompt you to choose a save location and then execute the backup command on the server.

From SQL Server Management Studio

IT administrators can also create backups directly from SSMS:

Right-click the database in Object Explorer
Select Tasks > Back Up...
Choose Full backup type
Select the destination path and click OK

Automated backups

For production environments, set up automated backups using SQL Server Agent (available in Express via sqlcmd scripts or Windows Task Scheduler):

Schedule nightly full backups
Retain at least 7 days of backup history
Store backups on a different drive or network share than the database
Test your restore process periodically to ensure backups are valid

Warning SQL Server Express does not include SQL Server Agent as a built-in service. Use Windows Task Scheduler with a sqlcmd script to automate backups on Express editions.

Restoring from Backup

Restoring a SQLite project

Locate your backup file — Find the .glyphfex backup copy you created earlier.
Replace the current file — Close GlyphFex, then copy the backup file over the current project file (or to a new location).
Open in GlyphFex — Use File > Open Project to open the restored file.

Restoring a SQL Server database

Disconnect all users — Ensure no one is connected to the database in GlyphFex.
Restore via SSMS — Right-click the database in SQL Server Management Studio, select Tasks > Restore > Database, select your .bak file, and click OK.
Reconnect in GlyphFex — Open your .glyphfex-server file to reconnect to the restored database.

Warning Restoring a database overwrites all current data with the backup contents. Any entries or changes made after the backup was created will be lost. Always verify you are restoring the correct backup file.

Export Full Project (ZIP)

For the most comprehensive backup, export your entire project as a ZIP archive:

Go to File > Export > Full Project ZIP or press Ctrl+Shift+E.
Choose whether to include attachments — GlyphFex will ask if you want to bundle all file attachments in the ZIP.
Save the ZIP file — Choose a location and filename. The archive includes the database, all configuration, and optionally all attached files.

The ZIP export is ideal for:

Off-site backup storage (e.g., cloud drive, external hard drive)
Transferring a complete project to another machine
Archiving a finished project for long-term retention

Note The Full Project ZIP export is restricted to Admin users only. Editors and Viewers cannot create ZIP exports.

Disaster Recovery Guide (PDF)

GlyphFex includes a built-in 9-page Disaster Recovery Guide designed for IT administrators. Access it from Help > Disaster Recovery Guide or via the Command Palette.

The PDF guide covers:

Backup strategies for both SQLite and SQL Server
Step-by-step restore procedures
Data verification after restore
Recommended backup schedules
Common failure scenarios and how to handle them

Tip Print the Disaster Recovery Guide and keep a copy near your server. In an emergency, having paper instructions available ensures you can restore operations even if you cannot access digital documentation.

Backup Best Practices

Back up daily — At minimum, create a backup at the end of each business day.
Store off-site — Keep at least one copy on a different physical device or cloud storage.
Test restores — Periodically restore a backup to a test environment to verify data integrity.
Retain multiple versions — Keep at least 7 days of daily backups so you can recover from issues discovered days later.
Document your process — Write down your backup procedure and share it with your team so backups continue even when you are out.