Post reply

DBCC Maintenance task failure

  • December 3, 2013 at 7:59 am

    #285643

    I am using SQL 2008 R2 10.5.2500

    I have a Maintenance plan, with 2 sub-plans. 1. CHECKDB for System Databases and 2. CHECKDB for User Database

    all was fine until about a week ago. The plan now fails with the following error. "Alter failed for Server". I have manually executed DBCC CHECKDB on every single database with no errors.

    I have found numerous articles on this, but they all refer to SQL 2005 SP2 and the result is to patch it.

    Some articles discuss Processor Settings, both Settings are enabled "Set processor affinity" and set "I/O affinity mask"

    I know I can, and probably should, just create my on SQL Agent job with T-SQL, but I really would like some help with this one.

    Thanks in advance...

    SQL Padre
    aka Robert M Bishop

    "Do or do not, there is no try" -- Yoda

  • December 3, 2013 at 8:48 am

    #1670420

    check your server configuration options to see if allow updates is set to 1. if it is set it 0

    sp_configure 'Allow Updates'

    sp_configure 'Allow Updates',0

    reconfigure

    here an article describing this. I believe maintenance plans do change server options thus run reconfigure.

    http://technet.microsoft.com/en-us/library/ms179262(v=sql.105).aspx

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

  • December 3, 2013 at 8:55 am

    #1670422

    Thank you!

    I'm not sure what changed or HOW it changed, or why a particular setting that is dubbed "The setting has no effect." worked, but it did.

    SQL Padre
    aka Robert M Bishop

    "Do or do not, there is no try" -- Yoda

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

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