Look after your data

How to repair and compact your data in Sage 50 Payroll.

You can use the repair option in Sage 50 Payroll to reduce your database size and help make your backups smaller.

This routine also helps to tidy up your data and prevent data corruption. We recommend running the routine once a month. 

You can also use the repair procedure if Sage 50 Payroll can't read your employee database. For example, if you're processing your payroll and an error message appears.

Examples of error messages:

• Cannot connect to Database
• Failed to Update
• Pay5

The Repair option repairs and compacts the data. You don't need to run the Compact procedure separately.

From Sage 50 Payroll v32, DBUtilities sorts your list of companies alphabetically. You can also use the filter to type a company name to find it on the list.

---

Things to check

Before you use DBUtilities.exe, we recommend you check:

• That you're running the software as an administrator
• Your Windows permissions and antivirus software

---

Repair your data

1. Close Sage 50 Payroll.
   If you have a multi-user licence, ensure any other users log out of the company you want to repair.
2. On the Windows desktop, right-click your icon for Sage 50 Payroll.
3. Click Open File Location.
4. Locate and double-click ' DBUtilities.exe'.
5. Select the required company, then Clear Locks.
6. Confirm that other users have logged out by selecting OK.
7. Click Repair. 
   • If the first repair fails, click OK, then click Repair to try again
     
8. Click OK, then click Close.

---