Restore filegroup from UI uses wrong script in version 5.0.x.
@filegroup parameter is missing from TQSL/CMD script in restore wizard.
Product defect.
WORKAROUND:
Run restore in Query Analyzer using tsql script:
-- Restore Full
EXEC master.dbo.xp_restore_database
@database='PartialTest'
, @filename= 'E:\BACKUP\SQL2005\PartialTest_Full.BAK'
, @filegroup = 'SalesGroup1'
, @WITH = 'REPLACE'
, @With = 'RECOVERY'
-- Restore particular filegroup into a new database.
exec master.dbo.xp_restore_database
@database='PartialTest_New'
, @filename= 'E:\BACKUP\SQL2005\PartialTest_Full.BAK'
, @filegroup = 'SalesGroup1'
, @with = N'MOVE N''Sales_log'' TO N''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\PartialTest_New_log.ldf'''
, @with = N'MOVE N''SGrp1Fi1_dat'' TO N''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\PartialTest_New.ndf'''
, @with = N'MOVE N''SGrp1Fi2_dat'' TO N''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\PartialTest_New_1.ndf'''
-- , @with = N'MOVE N''SGrp2Fi1_dat'' TO N''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\PartialTest_New_2.ndf'''
-- , @with = N'MOVE N''SGrp2Fi2_dat'' TO N''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\PartialTest_New_3.ndf'''
, @with = N'MOVE N''SPri1_dat'' TO N''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\PartialTest_New.mdf'''
, @with = N'MOVE N''SPri2_dat'' TO N''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\PartialTest_New_4.ndf'''
-- , @with = N'MOVE N''test1_dat'' TO N''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\PartialTest_New_5.ndf'''
, @With = 'RECOVERY' -- NORECOVERY for further restore
, @with = 'PARTIAL'
STATUS:
Fixed in a future release of LiteSpeed.
