Post reply

Consistency Errors

  • October 29, 2006 at 11:01 pm

    #60887

    Hi

    I have one database which size is 50 GB right now on sqlserver 2000 server box. I have cosistency errors in the database frequently after i fixed it and I checked the harddiks drive on server but i didnt find any errors in the disk. Do u have any idea why does it happend frequeltly in the database?

    Please guide me to solve the issue

    Thanks in advance

     

     

     

    Kindest Regards,

    karthik

  • October 30, 2006 at 5:26 am

    #668676

    There's plenty in BOL and Technet about dbcc commands.  Asking for this type of help is way to vague and doesn't help us help you. Consistancy errors are bad news and if they are re-occuring then you need to find out why and fix it. Make sure you have adequate backups in case you can't recover your database.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • October 30, 2006 at 11:57 am

    #668821

    Hi karthik,

    Did you look at Event Viewer (System) to see if there is any errors to disk ? My past experience in DBCC errors are all related to disk problems.

    Since disks are pretty cheap nowadays, I would replace them with new ones instead of keep fixing the errors. Make sure you back them up before you replace them.

    I also have a friend called Karthik. Do you recognize my name ?

    Jimmy Jen

  • October 31, 2006 at 12:05 am

    #668930

    Thanks Jimmy Jen,

    One of my hard disk failed in the array controller and raised ticket to the vendor to replace it immediately. gimme ur email id.

     

     

     

    Kindest Regards,

    karthik

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

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