SQL Server 2008 SP1 - Enterprise Edition
I have a database with multiple filegroups.
If I take a complete backup of the database, I can restore the most important filegroups and open the database to the users. I can then restore the remaining filegroups while the users are accessing the database,
The above test works.
I am trying to explore restoring filegroups from individual filegroup backups. Restoring filegroups one at a time and opening up the database to the users after restoring the most important filegroups. I want to then restore the other file groups while the
users are accessing the database. I am not able to accomplish this with restoring from individual filegroups.
I am not sure if this feature of partial restore is available only for a complete database backup and not for individual file group restores.
View Complete Post