Consistency Error in Checkdb

When I use DBCC CHECKDB I got allocation errors and
consistency errors. I use CHECKDB with
repair_allow_data_loss to fix it. It can fix the
allocation errors, but the consistency errors are still
there. How can I fix consistency errors?
Thanks,
Monica.First you need to check if you have any hardware issues or not. If you have
any hardware problem you need to fix them first. If the number of errors don
't happen to reduce, you can then mark the database in emergency mode and DT
S the objects and data to a
new database on the server. Once the transfer completes, make sure you run D
BCC CHECKDB on the new database. Once it comes out clean, drop the problem d
atabase, rename the new database to the old one.
This posting is provided "AS IS" with no warranties, and confers no rights.
http://www.microsoft.com/info/cpyright.htm|||Monica,
It depends what the errors are and which objects they are in. A very small
number of errors on critical tables cannot be repaired, in which case
you'll need to restore from your backups or extract as much information as
you can as suggested in the other reply.
Microsoft recommends that you have a backup strategy that allows you to
recover from hardware-caused corruptions rather than using the
REPAIR_ALLOW_DATA_LOSS option to CHECKDB, which as its name implies may have
to delete data to get the database back to a structurally consistent state.
If you're still stuck, please call Product Support
(http://support.microsoft.com) who will be able to assist you.
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Monica Clinton" <hv37@.yahoo.com> wrote in message
news:2fe501c3e1d1$9aef89f0$a001280a@.phx.gbl...

quote:

---

> When I use DBCC CHECKDB I got allocation errors and
> consistency errors. I use CHECKDB with
> repair_allow_data_loss to fix it. It can fix the
> allocation errors, but the consistency errors are still
> there. How can I fix consistency errors?
> Thanks,
> Monica.

---

|||Thanks for you help.
We fixed the hardware problem, now we are trying to fix
the data. How do I mark the database in emergency mode?
When we DTS the data to a new database, we had the same
errors. How to fix the errors?
Thank you.
Monica

quote:

---

>--Original Message--
>First you need to check if you have any hardware issues

---

or not. If you have any hardware problem you need to fix
them first. If the number of errors don't happen to
reduce, you can then mark the database in emergency mode
and DTS the objects and data to a new database on the
server. Once the transfer completes, make sure you run
DBCC CHECKDB on the new database. Once it comes out clean,
drop the problem database, rename the new database to the
old one.

quote:

---

>This posting is provided "AS IS" with no warranties, and

---

confers no rights.

quote:

---

>http://www.microsoft.com/info/cpyright.htm
>
>.
>

---