Community
Showing results for 
Search instead for 
Do you mean 
Reply

Backup cancelled

New Member
Posts: 7
Country: USA

Backup cancelled

Have Sage ACT! Pro 2013 Version 15.1.108.0. Got recent message when starting Office Outlook 2007 did I want to share database. Have never seen screen before.Clicked Yes.

 

Since that event unable to backup. Get following message:

 

The following error occurred during backup. Backup Cancelled.

Cannot insert duplicate row key in object ‘sys.syscommittab’ with unique index ‘si_xdes_id’. The duplicate key value is (1094276). Failed to flush the commit table to disk in dbid 8 due to error 2601. Check the error log for more information.

BACKUP DATABASE terminating abnormally.

PRC_MAINT_Backup DB:_ERROR EXECUTING DB BACKUP STATEMENT

The statement has been terminated.

 

Please help!

Silver Contributor
Posts: 1,813
Country: USA

Re: Backup cancelled

Try this kb article.

 

http://kb.sagesoftwareonline.com/app/answers/detail/a_id/28141/~/error%3A-%22cannot-insert-duplicate...

Test Drive Act! and Quickbooks over Citrix http://GoTryAct.com

Jon Klubnik| ActTrainer.com
(866)710 4228

ACT! Certified Consultant / ACT! Premier Trainer / ACT! Hosting Provider

New Member
Posts: 2
Country: USA

Re: Backup cancelled

I have the same issue. It just started.  And I've not been able to correct it with the MS HotFix/bat file operations.   Is this an SQL issue that Microsoft created?

 

Copper Contributor
Posts: 15
Country: USA

Re: Backup cancelled

I have this problem too although I have more than one database and it only happens on one of them.  If it is an SQL issue, and I only have the free version that shipped with ACT Pro 2013, shouldn't it happen with every database?  I'm frankly a little afraid to install a service pack as I really don't know what back end Act is running and Act itself works fine except for back up.  The same database also konks the the repair routine.

 

Am I safe, just copying the database files outside of the program or is that not a complete backup?

Copper Contributor
Posts: 15
Country: USA

Re: Backup cancelled

It looks like the link has moved to

 

http://kb.swiftpage.com/app/answers/detail/a_id/28141

 

There is also a Microsoft article at

 

http://support.microsoft.com/kb/2682488/en-us

 

I'm still not sure what to download though as I don't know what verison of SQL 2008 the Act software installed and there appear to be multiple hotfixes.

New Member
Posts: 2
Country: USA

Re: Backup cancelled

I have not solved the problem.  The chaps at ACT (Swiftpage) told me that you have to open the SERVICES.MSC, and stop the ACT SQL from running, then copy the entire database (folder and subfolders) to another location.  You have have ACT turned off at this time.

 

That seems like a pain, but if it ensures that the database is safe, it's worth looking into.

New Member
Posts: 7
Country: USA

Re: Backup cancelled

http://kb.swiftpage.com/app/answers/detail/a_id/28141

 

This link is good information to a point. For a non-technical person, the steps around the batch file are scary. I called ACT support and they fixed the problem. I followed the tech's verbal steps and, while I have some technical knowledge, I have no idea what we were doing. Bottom line - it worked.