I am getting the following (MOM) error on 3 of my databases anytime I initiate a backup of the mdf. The database seems to backup as expected. The one thing that has recently changed is I implemented MS Hotfix 2187 on my SQl cluster over the weekend.
Severity: Critical Error
Status: New
Source: MSSQLSERVER
Name: Commit record has already been distributed. Check DBTABLE
Description: Unable to expand message 17055 [-1073724769] 18264 Database backed up: Database: XX03PLUS, creation date(time): 2005/12/06(18:38:50), pages dumped: 23026, first LSN: 18761:44:1, last LSN: 18761:46:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'G:\temp\ar03PLUS_fromVCforK1.bak'}).
thanks in advance,
Jerry
I thought I would reply to my own post as I have remediated the error in case someone else ever has this issue.
AS it turns out the Hotfix 'upgrade' can create orphaned users and or users with 'not as expected' permissions. By deinstalling (detaching) and reinstalling (re-attaching) via an internal script that also reassigned appropriate users and permissions I wa able to clean up the errors.
best of luck,
Jerry
No comments:
Post a Comment