Coffalyser.Net stores all data in a Microsoft SQL Server database. Every installation of Coffalyser.Net includes a small tool that can help create a backup of data in a preconfigured server as created by the default installation procedure. The database can also be backed up using any other kind of backup technique for Microsoft SQL Server.

Creating a backup of a preconfigured database server

This procedure only works for preconfigured SQL Servers.

1. Start the SQL Server Backup Wizard from your start menu (in the folder Coffalyser.Net). If you do not have this shortcut, you can start the wizard directly via the file CoffalyserSqlServerBackupWizard.exe in the installation directory of Coffalyser.Net, which is by default at C:\Program Files (x86)\MRC-Holland\Coffalyser.Net.
2. You first get a dialog with a basic explanation of the tool's purpose. Click Next.
3. Select the database you want to back up and click Next.
4. The backup will be stored in the default backup location of the server. This is usually a folder like: C:\Program Files\Microsoft SQL Server\MSSQL10_50.COFFALYSER\MSSQL\Backup. Depending on the version of SQL Server the MSSQL10_50.COFFALYSER folder may be called differently, such as MSSQL12.COFFALYSER or MSSQL16.COFFALYSER. If the box Open the backup file(s) location is checked, this folder will be automatically opened after the backup.
5. Click Finish to close the wizard.

It is recommended to move the backup to a different location, such as a different hard drive or network share, as this increases the chance that data can be recovered if the original hardware fails.

Creating a backup of a custom database server

If you installed Microsoft SQL Server manually, you can create backups using any technique suitable for Microsoft SQL Server that you are comfortable with. Refer to Microsoft's documentation for more details. If you use a remote SQL Server, you may need assistance from someone with sufficient rights on the SQL Server.