Post reply

Maintenance Plan DB integrity check questions!!!

  • November 16, 2014 at 1:50 pm

    #291970

    I have almost a 1 TB database. Is Maintenance Plan wizard is good enough to check integrity check for all Databases? I notice that it has default 'NO_INFOMSGS', so it suppress all information, How do I know if some thing is corrupted? Should I need to read 'Error log' every time the job finishes? Or is there a way I will know after the job finishes if one (or more) database file (s) is corrupted?

    What's the best way to do this?

    Need advice please.

  • November 16, 2014 at 8:32 pm

    #1758859

    If corruption is found the SQL Agent job will show a failure for that database.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • November 17, 2014 at 5:43 am

    #1758947

    Thanks for the reply, one thing, will Agent job fail? or it run normally but shows on 'view history' (when I go thru all) that something is corrupted?

  • November 17, 2014 at 5:46 am

    #1758950

    As Shaun said, the SQL Agent job will show a failure.

    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

  • November 17, 2014 at 8:16 am

    #1758997

    Does it mean the fails? if i set up notification will it send out an email?

  • November 17, 2014 at 8:20 am

    #1759000

    FWIW - "no_infomsgs" does not suppress errors and corruption. It just suppresses the informational messages that most people discard anyway.

    As for the agent job, if there is corruption, it will show the job has failed.

    If you create a notification for that to send an email, it should send you an email.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • November 17, 2014 at 9:22 am

    #1759017

    Great.Thank you

  • November 17, 2014 at 11:23 am

    #1759051

    Pick a very small database and run the Integrity check in Mgt Studio with and without the No info mgs and you will see what they mean. If you have errors they will showup regardless.

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

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