Restore a database backup
Always use ROBOTILL Database Setup to restore a backup. The Database Restore option in Back Office opens this tool. A restore must also update the database's identity and application connection settings. Restoring directly with SQL Server tools or other software skips these steps and may cause the database to be treated as a duplicate installation.
A restore is for recovering your shop's data. It replaces current data with the backup's contents. Sales and changes made after that backup will be lost.
- On the main computer, open Back Office > Home > Database > Restore Database. This opens ROBOTILL Setup. You can also use Database Setup > Advanced / support > Restore Database from Backup on the first advanced-tools screen.
- Close ROBOTILL on all computers and choose your full .bak backup file. The SQL Server service must be able to read its location; ask support if it reports a file-access error.
- Follow the prompts for the administrator connection and, if needed, the data folder. Check the source and destination, then type RESTORE to confirm. Setup requires a verified backup of the current database before replacing it.
- When the restore completes, use a fresh setup file to reconnect the additional computers. Restoring creates new application connection credentials.
Backups created by older ROBOTILL versions without backup checksums are supported. Setup still verifies the backup before replacing any data and checks checksums when the backup contains them.
Restoring to a different data folder
If the backup's original data-file locations cannot be used, your IT provider can supply the absolute SQL Server data-folder path when prompted. Setup reads the file names from the backup. Use Save support log if the restore cannot finish.
See ROBOTILL Setup - Advanced tools for recovery options.