Database Restore

Warning: When you do a database restore any data that was added after the backup was done will be lost.

A restore can only be done if you have a backup file that was done with a ROBOTILL backup. To do a restore, go to Manager > Tools > Database Tools > Restore Database.

Restore ROBOTILL Database
  1. Select your backup file. Note that your backup file should not be in a user folder like 'Desktop', 'Documents' or 'Downloads'.
  2. Check the box to confirm you want to do the restore (see the warning on top of this page).
  3. Close any ROBOTILL applications that is open on any computer and click on 'Restore Database'

Restore with Move

Use the instructions above to do a restore. A 'Restore with move' is only needed if you get the error below.

Restore Error

If you did get the error above it is usually because you moved from a SQL 32 bit server to a 64 bit (or the other way round). In that case, follow the instructions below.

You first have to find the location of the new database files. Using File Explorer navigate to the MSSQL12.ROBOTILL\MSSQL\DATA folder. It will be in one of the following locations.

  • C:\Program Files\Microsoft SQL Server\MSSQL12.ROBOTILL\MSSQL\DATA
  • C:\Program Files (x86)\Microsoft SQL Server\MSSQL12.ROBOTILL\MSSQL\DATA

Depending on how your Windows is installed the path or drive letter might be slightly different. Make sure to navigate to the DATA folder. You might be asked if you want to continue as it requires user permission.

Restore with move

Keep the data folder open in file explorer (to avoid permissions issues). Then do the restore again but this time use the 'With Move' option.

Restore with move

Click on Browse in the 'With Move' section and select your SQL Server data folder. Select the folder you have open in File Explorer (remember it must have MSSQL12.ROBOTILL\MSSQL\DATA as part of the path) and click on 'Restore Database'