Backups Fail from time to time

  • From time to time I receive the following message: Violation of PRIMARY KEY constraint 'PK__syscachedcredent__3F9B6DFF'. Cannot insert duplicate key in object 'syscachedcredentials'. and the backup fails. I run roughly 40 backups of various, smaller databases in a two hour window. It's a SQL 7.0 sp3, NT4.0 environment and just seemed to start happening within the last month or so. Any ideas?

    Terry


    Terry

  • Try running DBCC CHECKDB to see if you have any errors.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply