SERRAM POS Database

Backup and Restore

It is important to do regular backups. It is also advisable to store the backup file on another device in a separate location. You could use a cloud service like Google Drive to make sure you can recover if you have a hard drive failure.

To do a backup or a restore, go to Manager > Tools > Database Tools.

The backup uses the SQL Server utility to do the backup. SQL Server does not allow you to create backups in some locations like directly in the root folder (c:\) or in the Documents folder. You could create a backup folder like 'C:\SERRAMBackup' where you can do the backups.

Reset Database

You can use the Database Reset to reset the database after you did some testing or training. You can choose to delete all sales and payments but leave the stock or delete the stock as well.

The departments, categories, users and print setup will not be deleted. To do a database reset, go to Manager > Tools > Database Tools > Database Reset.