Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Thankfully, this question is just a what-if, and I am not in an emergency right now.

But I have created a file group in my database (sql server 2008), and moved some massive data tables over to it. Leaving my websites central tables in the Primary file group.

In the event of a restore, can I restore just the primary file group, and have a working database? Or do I have to restore both file groups?

I don't want my site down for ages while it restores the 2nd file group.

share|improve this question
    
You edited out my "Thanks" ?? Interesting. –  bladefist Nov 21 '11 at 2:34
    

1 Answer 1

up vote 1 down vote accepted

Technically, the answer is "yes, you can do this". http://msdn.microsoft.com/en-us/library/ms175199.aspx should have everything you need. However, you have to design your database and application properly to be able to do this sort of thing. That is, will your application function properly in the absence of those tables? That's something you're going to want to test before you rely on it.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.