SQL Server Restore from Backup, Just primary File Group
- by bladefist
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.