does the microsoft sql capable of fixing itself?

Posted on 2009-12-23
Last Modified: 2012-05-08
i have on one of our servers Microsoft sql server 2005 and one day i recieved an error from our monitoring application that there is an error in the one of the databases so i checked it out and i got 1 consistency error with a repair_allow_data_loss minimum repair level so i started filling up the paper work to fix the error on next day but when i checked the next day i DBCCed the database and it turns out to be magically fixed.. so i decided to wait another day and on next day i got a different error (2 consistency erros ) and on the next day i got 2 consistency errors but on different page and today i got an error with 1 consistency?

so what could be wrong? bcause the application we have is running on 70+ servers and it gives accurate results.
Question by:Co0L_DBA
    LVL 57

    Accepted Solution

    No.. There is no automatic procedure to fix it out..
    Either your problematic data is corrected either by DELETE / UPDATE statements or some Rebuild / Reorganize index operations should have fixed it out..

    Kindly run this script to find any errors in your database..

    USE ur_db_name

    Assisted Solution

    either those consistency erros were on indexes and you have a job rebuilding them or someone else is fixing it for you.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now