an I restore a full backup into separate filegroups?
My manager has just asked me to research whether it would be possible to restore a previously fully backed up database into two or more filegroups, with each filegroup being on a separate drive using SQL Server 2008. I know that if I were backing up the database to begin with, I could do filegroup backups. But this backup has already been performed, and my boss wants to know if it can be restored to two different drives using filegroups. Any suggestions?
bajanpoet
Junior Poster in Training
96 posts since Sep 2006
Reputation Points: 10
Solved Threads: 0
No ... you're backing up a copy of an existing database, so you want to restore the database as-it-was. The original database should have multiple filegroups if that is how you are intending for it to operate. You could basically duplicate the structure and replicate the data to the new DB to get around this.
sknake
Industrious Poster
4,954 posts since Feb 2009
Reputation Points: 1,764
Solved Threads: 735
Great help... thanks a lot!!
bajanpoet
Junior Poster in Training
96 posts since Sep 2006
Reputation Points: 10
Solved Threads: 0
You're welcome
Please mark this thread as solved if you have found an answer to your question and good luck!
sknake
Industrious Poster
4,954 posts since Feb 2009
Reputation Points: 1,764
Solved Threads: 735
