Knowledge Base

Repairing the SQL Backup server-side data store

Category: Troubleshooting & error messages
Date: 21 Apr 2009
Product: SQL Backup
When backing up or restoring using SQL Backup, this message may appear in the backup file properties:

Warning 166: Failed to delete old entries in local history tables: Error running ExecFast command: Floating point division by zero.

This may be caused by a corrupt SQL Backup data file on the SQL Server.

To fix the corruption, you need to repair the database. To do this:

- Start up SQL Server Management Studio 2005 on the server where the errors are occurring
- Select 'SQL Server Compact Edition' as the Server Type, select the data.sdf file on your system, do not enter any password, click Connect
   - The data.sdf file is usually found in the %allusersprofile%\application data\red gate\sql backup\data\(local) folder. On a named instance, replace (local) with the instance name.
- Once connected, right click on the database node in the Object Explorer, select Properties
- Select the 'Shrink and Repair' page, select the 'Repair physically corrupted database' option, select the 'Recover corrupted rows' option.
- Click OK

Once this is done, try running a backup and see if the error still occurs. If it does, repeat the above steps, but do not select the 'Recover corrupted rows' option.