Run the following scripts from a command line:
--backup individual filegroups (in any order) then backup log
exec master.dbo.xp_backup_database @database = 'mywind'
, @fileGroup = 'new_customers'
, @filename = 'C:\mssql\dts\mywind_nc.bak'
exec master.dbo.xp_backup_database @database = 'mywind'
, @fileGroup = 'PRIMARY'
, @filename = 'C:\mssql\dts\mywind_p.bak'
exec master.dbo.xp_backup_database @database = 'mywind'
, @fileGroup = 'sales'
, @filename = 'C:\mssql\dts\mywind_s.bak'
exec xp_backup_log @database='mywind'
, @filename='c:\mssql\dts\mywind_log.bak'
--restore individual filegroups (starting with primary) then restore log
exec xp_restore_database @database='mywind_partial'
, @filename='c:\mssql\dts\mywind_p.bak'
, @filegroup='primary'
, @with='MOVE "mywind" to "c:\mssql\data\mwp.mdf"'
, @with='MOVE "mywind_log" to "c:\mssql\data\mwp_log.ldf"'
exec xp_restore_database @database='mywind_partial'
, @filename='c:\mssql\dts\mywind_nc.bak'
, @filegroup='new_customers'
, @with='MOVE "mywind_data_1" to "c:\mssql\data\mwp.dat1"'
, @with='MOVE "mywind_log" to "c:\mssql\data\mwp_log.ldf"'
exec xp_restore_database @database='mywind_partial'
, @filename='c:\mssql\dts\mywind_s.bak'
, @filegroup='sales'
, @with='MOVE "mywind_data_2" to "c:\mssql\data\mwp.dat2"'
, @with='MOVE "mywind_log" to "c:\mssql\data\mwp_log.ldf"'
exec xp_restore_log @database='mywind_partial'
, @filename='c:\mssql\dts\mywind_log.bak'
, @with='MOVE "mywind_log" to "c:\mssql\data\mwp_log.ldf"'
