Post reply

DBCC commands to Check Data and Index Linkage??

  • October 1, 2008 at 1:08 pm

    #213516

    hi,

    Could please tell me what are the DBCC commands need run to 'check Data and Index Linkage' of the database?

    My maintenance plan Integrity check job is failed in production box So I need test it manually through Query analyzer by running the appropriate DBCC commands.

    Error in job properties: sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed

    Error Message in Maintenace plan history:[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not processed. Database needs to be in single user mode.

    Only One database is failing and Iam sure that no other users using that database.

    In Maintenance plan History it is exactly like below:

    Maintenance plan Server Database Activity Status End date Message

    Maintenanceplan1 ABC ABC check data and index linkage Failed xyz above mentioned message

    Thanks

  • October 1, 2008 at 1:57 pm

    #879723

    DBCC CHECKDB( < Database name > ) WITH NO_INFOMSGS

    Post the output here, and we can help you interpret it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 1, 2008 at 3:25 pm

    #879753

    Is this in fact a SQL 2000 server? The details of error certainly suggest it is. This sounds exactly like the error you get out of maintenance plan integrity check job when you have the repair option ticked, and it cannot do that unless db is in single user mode.

    It is not saying you have a corruption, just if you want that option db must be in single user mode.

    Untick the 'attempt to repair any minor problems' box in the maintenance plan.

    ---------------------------------------------------------------------

  • October 1, 2008 at 10:01 pm

    #879808

    Hi,

    Iam also run into the same issue. can anybody give some ideas.

  • October 1, 2008 at 10:27 pm

    #879810

    thanks Gail,

    I ran the DBCC CHECKDB (database_name) with no_infomsgs in the production box after hours.

    Iam getting the message 'The command(s) completed successfully'

    No errors occurred. Is there any other DBCC commands to check The data and index linkage?

    Thanks agian

  • October 2, 2008 at 4:27 am

    #879863

    did u read my post kotlas7? your first post mentions query analyser and sqlmaint, so this must be SQL2000. Please confirm that.

    HAve you checked the maintenance plan options?

    ---------------------------------------------------------------------

  • October 2, 2008 at 5:45 am

    #879886

    kotlas7 (10/1/2008)

    Iam getting the message 'The command(s) completed successfully'

    No errors occurred. Is there any other DBCC commands to check The data and index linkage?

    Then you have no corruption. That's the command that does all of the integrity checking. See George's post for why you may be getting the message.

    If this is a 2000 server, then in the future please post 2000-related questions in the SQL 2000 forums.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 2, 2008 at 9:53 am

    #880042

    Yes George Its sql server 2000 with sp4

  • October 2, 2008 at 10:00 am

    #880050

    thought it might be. Then you have a fix for the problem and you rest assured your Db is not corrupted. 🙂

    ---------------------------------------------------------------------

  • October 3, 2008 at 12:59 am

    #880306

    Hi Gail Shaw,

    I observed that the Optimization and Intigrity checks jobs are scheduled to run at the same time.

    Is this cause to fail the intigrity job?

    But these 2 jobs running at the same time from past 6 months. So Iam confused and I did not resolve this issue so for. Any more information on this issue?

    Thanks

  • October 3, 2008 at 1:23 am

    #880316

    kotlas7 (10/3/2008)

    Hi Gail Shaw,

    I observed that the Optimization and Intigrity checks jobs are scheduled to run at the same time.

    Is this cause to fail the intigrity job?

    No.

    George said exactly why the job is failing. See his first reply to this thread.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 11 posts - 1 through 10 (of 10 total)

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