DBCC CHECKDB ('dbname' repair_allow_data_loss). If that doesn't work,
drop the index, run the DBCC again, recreate the index.

Note you have to put db in single user mode to run the DBCC with any
repair option.

If you can't stand the data loss, try it with milder parameters. See BOL
for these.

Usually you get torn pages from hardware or power failure. Check
hardware (controller is likely) and get UPS if you don't have it.

Daniel Morphett
DBA
Brilliant Digital Entertainment
02 9281 9272


-----Original Message-----
From: Vallipuram Suganthan
[mailto:mssqldba-ezmlmshield-x52089323.[Email address protected]
Sent: Thursday, July 29, 2004 2:05 PM
To: LazyDBA Discussion
Subject: How can I avoid Torn pages

Dear Friends,

Could anyone please let me know how can i delete torn pages from my
database
and reindex the tables.

Thans in Advanced.

Rgds,
VSN


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]



MS Sql Server LazyDBA home page