more Quotes
KB 28141 Problems with Backup

Error: ""Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'" When Attempting to Backup or Repair a Sage ACT! Database



You are attempting to create a backup or run maintenance on your Sage ACT! database, and receive the error: ""Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'".

This problem seems limited to ACT! 2012 and not with earlier versions. Some additional erros for backup are covered in this article as well.


This is an error associated with Microsoft® SQL Server® 2008 R2. This issue can be resolved by running one of the batch files found in the File Attachments section near the bottom of this article.

  • If you are using SQL Server 2008 R2 Express (The default ACT! installation, use SQL2008R2_Express_BackupFix.bat
  • If you have installed SQL Server 2008 R2 Standard, use SQL2008R2_Standard_BackupFix.bat
  • Step 1.    To run this file: Click on the appropriate file below, and choose the Save option. Save it to your desktop. If your database is on a server you should save the file to the Server.

    Step 2.    Close Sage ACT!

    Step 3.    Locate the file you downloaded and double-click on it to run it.

    Step 4.     After the file runs, click your Windows® Start button, and on the Start menu either click Run or go to the Search box at the bottom of the Start menu. Type in services.msc.

    Step 5.    In the list of services, locate SQL Server (ACT7).

    Step 6.    Right-click on this service and select Restart. Close the services window.

    Step 7.    Reopen Sage ACT! and make a backup of your database to test.

    Step 6.    Provided this was successful you can retest

      download SQL2008R2_Express_BackupFix.bat (0.47Mb)

      download SQL2008R2_Standard_BackupFix.bat (0.38Mb)

Helping you turn more prospects into Customers

© Copyright 2012  All rights reserved. Last Updated Tuesday, July 17, 2012
TAGS: Crm made easy, making CRM successful, How to Benefit from CRM, Continuous Improvement, CRM Success Tips, CRM Strategy, CRM Database, Integrity, CRM Effectiveness, Marketing Strategy, Campaigns ACT Software - ACT! Software Support - Australian ACT Consultants - Australian ACT Support Australian ACT! Support


Helping you turn more prospects into customers

Quick links

Windows Tips & Tricks
Some Windows tips to help you become more productive.

ACT! Tips & Tricks
A range of tips for ACT! users to save you time.

Remote Support
When you have a problem we may be able to connect to your machine remotely and resolve without having to schedule an on-site visit.

Existing Clients
Our client list may be in your industry.

Find updates for your system.