How can I restore only 1 file out of 10 file?\

[madan agarwal]

HI All,

I have one database that cantain 10 primary file(.mdf and .ndf) and out of it 1 file get corruptted.

My backup shedule:
Full backup in sunday day at 7 PM.
And differential backup at every 12 hour.

Now i have to restore only one corrupted file.So what the best method to do it.

[Delerna]

Don't know if its the best method but you could restore all 10 to another database and then you can get the corrupted one from there