What is The Concept of Piecemeal Restore on SQL Server ?
Online PIECEMEAL RESTORE is available from SQL Server Enterprise Edition, this allows administrators of databases that employ multiple filegroups to restore missing filegroups in stages while the database is online.