Showing results for 
Search instead for 
Do you mean 

ACT! back-up failure

New Member
Posts: 3
Country: USA

ACT! back-up failure

I am somewhat computer-challenged. I am using ACT! Pro 2012 and the back-up has stopped working. I get an error message that reads:


Cannot inset duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'.

Failed to flush the commit table to disk in dbid 7 due to error 2601.

Check the error log...

BACKUP DATABASE is terminating abnormally.



I know that I can spend ~$100 and get someone at Sage  to help me, but I figured maybe someone out there can give me some helpful information.


Any ideas?



Nickel Elite Contributor
Posts: 988
Country: USA

Re: ACT! back-up failure

[ Edited ]

Hello Zissel,


You did not disclose your complete version/build of ACT!2012 Pro

  ex: Sage ACT! Pro 2011 Version, Hot Fix 6


You may need to install the most current service pack/hot fixes?

Reference Download Center link 


Are you trying to backup the Main database/server/publisher  or a remote database?


 but it sounds like you are trying to take a ACT! backup while syncing the database at same time?

   No can do.


Take a look at ACT! / Tools / ACT! Scheduler


Hope this helps

Reference KB article


Cheers - FSB


Bill Williams - Owner / ACT! Consultant / Trainer at FILL STAFF HR "ACT! FOR RECRUITERS"
Manage Your ACT! Backups - FREE
Backup your ACT! Databases DAILY using ACT! / File/ Backup/ Backup Database.(Include Attachments).
Also - FREE - BIG ACT! LAYOUTS for Larger Monitors
Also - FREE - BullZip PDF Printer - Print directly to PDF
Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: ACT! back-up failure

Hello Zissel,

This is an error associated with Microsoft SQL Server. The best way to resolve this is to apply the Service Pack 1 for the SQL Server 2008 R2, then run a batch file that Sage created to fix the database. Details and instructions are in this Knowledgebase article:


Please note that if you are using a shared database, the procedures in the article must be done on all machines.

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.