Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  PARTIAL RESTORE

Author  Topic  Acedude Starting Member 3 Posts Posted - 2009-03-06 : 20:12:05 Ok guys, this is my situation here: My production database is in the size of TBs and the single largest table (say BIG_TABLE) contributes about 75% of the the entire size of the database. BIG_TABLE spans across 13 file groups. I would like to know if i can restore a subset of this database to a different server(maybe a test server). Since my test server is only that big there are constraints on the amount of data I can get in. By partial restore, i mean restoring the PRIMARY,LOG and the intended file group together. And I am doing this from a FULL backup file (not at a file group level) The only situation this will work is when the table is not striped across several file groups(which is not the case with BIG_TABLE). I tried it and it works just fine. I do not know how to make this work when the table spans several file groups. Can somebody please help me out? Thank you!