How can we help you today? How can we help you today?

restore filegroups

I have a big database so I created diferent schemas for the different areas stored in the database. I have different filegroups, one for each scheme so if I have a problem with some tables from a specific schema I don't have to restore the whole database.
The problem is I heven't managed to make this work. I've been doing some test, but when I restore a filegroup th e information of my tablas doesn't change. I mean if I have wrong data in my tables and I restore the filegroup with a backup made before I got the wrong information I don't get the rigth data back.
When I restore a filegroup isn't is supposed to restore the data as well?
Many thanks[/b]
hgg
0

Comments

2 comments

Sort by
  • Eddie D
    Thank you for your post into the forum.

    I suspect that you need to apply the transaction log backups taken in the period after you performed the backup of the Filegroup.

    This link is to a Knowledge Base Article which explains the steps required:
    FilegroupRestore

    Hope this helps.

    Many Thanks
    Eddie
    Eddie D
    0
  • hgg
    Thanks for your reply Eddie, but the link you posted is the same document I use to restore the filegroups, I followed all the steps but still I get the wrong data.
    Any idea?
    Thanks

    Helen
    hgg
    0

Add comment

Please sign in to leave a comment.