Post reply

DB Corruption

  • March 24, 2009 at 4:58 am

    #73618

    Hi,

    How do I check the DB corruption in sqlserver 2000 db.

    Thanks,

    Kindest Regards,

    karthik

  • March 24, 2009 at 5:47 am

    #965080

    DBCC CHECKDB reports inconsistencies if any. Details are here

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • March 24, 2009 at 6:56 am

    #965122

    I ran the checkdb in my prod db and I got the below output.

    CHECKDB found 0 allocation errors and 0 consistency errors in database 'Sales'.

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    Thanks,

    Kindest Regards,

    karthik

  • March 24, 2009 at 9:30 am

    #965322

    if it shows 0 error then it means no error and database is fine. To assure nothing wrong with it also check sql server errror log and vevent viewer. if database color is yellow it means it fines. suspect mode database are usually gry. If you are asking interms of data corruption then you have to contact application team who loaded the corrputed data and ask them toload correct data again

    :crazy: :alien:

    Umar Iqbal

  • March 24, 2009 at 10:20 pm

    #965776

    Thanks to All

    Kindest Regards,

    karthik

Viewing 5 posts - 1 through 4 (of 4 total)

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