You’re offline. This is a read only version of the page.
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
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.
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (