Post reply

Error received as part of nightly backup

  • February 9, 2007 at 3:53 pm

    #68273

    Greetings... we use BackUp Exec to do nightly backups and have started receiving this error as part of the process...

    "An unknown or unexpected database error occurred while attempting a DBCC. DBCC failed because the following SET options have incorrect settings: 'ARITHABORT'. "

    The backups are apparently getting done successfully, but I'm new enough that I don't know why we get this error.

    Can someone give me some pointers?

    Thanks,

    Bob

     

  • February 9, 2007 at 6:20 pm

    #689009

    Did you just add a table with a computed column, add a computed column to an existing table, or create an indexed view?

     

  • February 12, 2007 at 10:20 am

    #689246

    Here's a KB article describing the situation we found when using MOM 2005:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;301292

    Also, here's an MS supplied script to help get around one portion of the maintenance issue:

    SET ANSI_NULLS ON

    SET ANSI_PADDING ON

    SET ANSI_WARNINGS ON

    SET ARITHABORT ON

    SET CONCAT_NULL_YIELDS_NULL ON

    SET QUOTED_IDENTIFIER ON

    SET NUMERIC_ROUNDABORT OFF

    GO

    EXEC SP_MSForEachTable "DBCC DBREINDEX ('?')"

    GO

     

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

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

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