Error 8905

I am getting a lot of corruption reports in my database and the performance
is down dramatically. The MS support site says I can fix this this a
checkdb repair with data loss. I run the repair over and over and no
change.
CHECKALLOC found 951 allocation errors and 0 consistency errors in database
'envision'.
repair_allow_data_loss is the minimum repair level for the errors found by
DBCC CHECKALLOC (envision ).
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
We are on SQL 2000 service pack 4.
Any ideas'
Thanks!
RichardResolving Errors
If DBCC CHECKALLOC reports any errors, we recommend that you restore the
database from the database backup instead of running a repair. If a backup
does not exist, running a repair can correct the reported errors; however,
correcting the errors might require some pages, and therefore data, to be
deleted.
A repair can be performed in a user transaction. This allows for changes to
be rolled back. If changes are rolled back, the database will still contain
errors and must be restored from a backup. After the repairs finish, back up
the database.
Good luck!
I drank alot of beer and ended up in the police department database.
Drank more beer and learned SQL in the dark hours.
DELETE FROM offenders WHERE Title=''MrAA'' AND Year=2006;
I love SQL
"Richard Douglass" wrote:

> I am getting a lot of corruption reports in my database and the performanc
e
> is down dramatically. The MS support site says I can fix this this a
> checkdb repair with data loss. I run the repair over and over and no
> change.
> CHECKALLOC found 951 allocation errors and 0 consistency errors in databas
e
> 'envision'.
> repair_allow_data_loss is the minimum repair level for the errors found by
> DBCC CHECKALLOC (envision ).
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> We are on SQL 2000 service pack 4.
> Any ideas'
> Thanks!
> Richard
>
>