restore filegroups

hgg · October 28, 2008 4:39AM

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]

Eddie D · October 28, 2008 3:36PM

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

hgg · October 29, 2008 3:30AM

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

restore filegroups

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk