What are the challenges you face when working across database platforms? Take the survey

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]


  • Options
    Eddie DEddie D Posts: 1,793 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:

    Hope this helps.

    Many Thanks
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Options
    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?

Sign In or Register to comment.