Many thanks to all your prompt reply to queries on this website.

Eric :

Scenario : A sql server 7.0 database has one .mdf file and more than one .ndf files and a .ldf file.If a database gets corrupted, is there anyway to just repair one of the data files (mdf or ndf) instead of restoring the entire database.Secondly how do we verify which data file has the corruption.Thirdly will the database maintain its integrity if one of the data file is repaired.

I have a 30 GB production database...and i want to make sure that i dont run into problems like the ones cited above.

Thanx Prem

-- Anonymous, July 31, 2001

Answers

Prem,

DBCC CHECKDB allows you to use one of the following options:

REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST| REPAIR_REBUILD

This increases the chances of being able to recover the database.

Hope this helps,

Eric

-- Anonymous, August 21, 2001