restore filegroups

hgghgg Posts: 3
edited October 29, 2008 3:30AM in SQL Backup Previous Versions
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]

Comments

  • Eddie DEddie D Posts: 1,643 Rose Gold 5
    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 Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
  • 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
Sign In or Register to comment.