472,125 Members | 1,373 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,125 software developers and data experts.

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

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.
Dec 18 '08 #1
1 1197
1,134 Expert 1GB
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
Dec 18 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Tim Morrison | last post: by
3 posts views Thread by butatista | last post: by
9 posts views Thread by GL | last post: by
11 posts views Thread by Chris | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.