943,779 Members | Top Members by Rank

Web Development > Databases > MS SQL > an I restore a full backup into separate filegroups?
Ad:
  • MS SQL Discussion Thread
  • Marked Solved
  • Views: 595
  • MS SQL RSS
Permalink
Aug 12th, 2009
0

an I restore a full backup into separate filegroups?

Expand Post »
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?
Similar Threads
Reputation Points: 10
Solved Threads: 0
Junior Poster in Training
bajanpoet is offline Offline
96 posts
since Sep 2006
Permalink
Aug 18th, 2009
0

Re: an I restore a full backup into separate filegroups?

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.
Featured Poster
Reputation Points: 1749
Solved Threads: 735
Senior Poster
sknake is offline Offline
3,948 posts
since Feb 2009
Permalink
Aug 18th, 2009
0

Re: an I restore a full backup into separate filegroups?

Great help... thanks a lot!!
Reputation Points: 10
Solved Threads: 0
Junior Poster in Training
bajanpoet is offline Offline
96 posts
since Sep 2006
Permalink
Aug 18th, 2009
0

Re: an I restore a full backup into separate filegroups?

You're welcome

Please mark this thread as solved if you have found an answer to your question and good luck!
Featured Poster
Reputation Points: 1749
Solved Threads: 735
Senior Poster
sknake is offline Offline
3,948 posts
since Feb 2009

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS SQL Forum Timeline: Website Form -> SQL Database injection help/guide?
Next Thread in MS SQL Forum Timeline: how to insert data into 2 tables in single query/





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC