File group backup

  • Hi Every body,

    In my database 3 file group is there, every day we will take t-log every one hour to day at 11:30 2nd file group was corrputed

    How can i restore can any body suggest me

    Regards

    Raj

  • Have you got a full backup?

  • Restore the database from the last full backup using the NORECOVRY option, and then apply the transaction logs to roll forward to the point in time that you want to recover to.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply