Post reply

DB Corrupt

  • January 22, 2009 at 1:34 am

    #130317

    How to find MDF or LDF is Corrupted?

    Plz give ans

  • January 22, 2009 at 1:53 am

    #930928

    check status in sysdatabases must be suspect for corrupted mdf files

  • January 22, 2009 at 1:56 am

    #930929

    First post it in the right forum. You need to run DBCC CHECKDB command to find out if there is any corruption I mean incosistency in your DB. some time the error message will give information if it is a mdf corruption

    example:

    server: msg 823, level 24, atate 2, line 1

    I/O error (bad page ID) detected during read at offset 0x00000007b7e000 in file '... dbname.mdf'

    "More Green More Oxygen !! Plant a tree today"

  • January 22, 2009 at 3:57 am

    #930979

    Run checkDB and see if it gives you any errors. There are a lot of possible errors that checkDB will give back, so I won't try and list them.

    Is this a theoretical question, or do you think you have a corrupt database?

    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

  • January 22, 2009 at 4:01 am

    #930982

    Hadrian (1/22/2009)

    check status in sysdatabases must be suspect for corrupted mdf files

    Not necessarily. There are many forms of corruption that won't result in the DB been marked suspect. That's pretty much a worst-case.

    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

  • January 23, 2009 at 2:32 am

    #931690

    Lee From Bangalore (1/22/2009)

    How to find MDF or LDF is Corrupted?

    Plz give ans

    IT MAY BE ANY REASOM LIKE LOG FILE IS OUT OF SPACE..

    U CAN RUN DBCC CHECKDB TO RESULTOUT..

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • January 23, 2009 at 7:18 am

    #931775

    what about checking the error logs?

    _________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie

  • January 23, 2009 at 7:27 am

    #931782

    Swirl80 (1/23/2009)

    what about checking the error logs?

    checking the error logs can alert you to possbile corruption, but the only sure fire way is to use DBCC CHECKDB.

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

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