Dynamics system backup error

(0) Share

Report

Posted on by Mike_Normal

480

We are using a SQL Server Management Plan to backup the databases (DYNAMICS and our company's Dynamics databases). The Plan we wrote is successful backing up everything, but stumbles on the DYNAMICS database. The error is:

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

When we try to backup the System database within GP 2013 application, we also get an error (warning dialog is not specific). Backing up the company database from within GP 2013 is successful.

Any ideas on what we need to change?

*This post is locked for comments

All responses (3)

Answers (0)

Jonathan Fear on at

Like (0)

Report

RE: Dynamics system backup error

Hi Mike,

I would post this in the SQL forums as this is an issue on the SQL side so they will probably be able to better help.
Mike_Normal 480 on at

Like (0)

Report

RE: Dynamics system backup error

We installed the latest service pack version and updates to SQL 2008 before installing Dynamics GP2013 (about two weeks ago). Here is more details from the errors posted:

Command:

BACKUP DATABASE [DYNAMICS]

TO DISK = N'SomePath\DYNAMICS\FULL\SQL_DYNAMICS_FULL_20130412_210004.bak' WITH CHECKSUM, NO_COMPRESSION

Msg 2601, Level 14, State 1, Server SQL, Procedure sp_flush_commit_table, Line 15

Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'. The duplicate key value is (55440).

Msg 3999, Level 17, State 1, Server SQL, Line 1

Failed to flush the commit table to disk in dbid 7 due to error 2601. Check the errorlog for more information.

Msg 3013, Level 16, State 1, Server SQL, Line 1
Mariano Gomez 26,225 on at

Like (0)

Report

RE: Dynamics system backup error

This was a known issue pre in the RTM version of SQL Server 2008 R2. This problem has since been fixed in SQL Server 2008 R2 SP1.

support.microsoft.com/.../2527041

If applying the latest service pack does not work, you may need to rebuild your SQL Server instance.

msdn.microsoft.com/.../cc646006(v=sql.105).aspx