Re : Data File corruption : LUSENET : SQL Server Database Administration : One Thread

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



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


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

Hope this helps,


-- Anonymous, August 21, 2001

Moderation questions? read the FAQ