does the microsoft sql capable of fixing itself?

Posted on 2009-12-23
Medium Priority
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

Raja Jegan R earned 1600 total points
ID: 26112563
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

Thiago_Dantas earned 400 total points
ID: 26119201
either those consistency erros were on indexes and you have a job rebuilding them or someone else is fixing it for you.

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

809 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