LiteSpeed FileGroup and piecemeal restores require filename (unlike native SQL Server)
Native backup/restores are handled with the below syntax
EXEC master..xp_backup_database
@database='database_name',
@filename=' \\server_namesqlddump\savedbackups\database_name_readwrite.bak<file:///\\server_namesqlddump\savedbackups\database_name_readwrite.bak>',
@filegroup='test_filegroup3',
@with='partial',
@with='recovery'
RESTORE DATABASE database_name
FILEGROUP = 'readonlytables',
FILEGROUP = 'readonlytables2'
--FROM disk = N'\\server_namesqlddump\savedbackups\database_name_readonlyfg.bak'
WITH RECOVERY
EXEC master..xp_backup_database
@database='database_name',
@filename='\\server_namesqlddump\savedbackups\database_name_readonlyfg.bak',
@filegroup='readonlytables',
@filegroup='readonlytables2',
@with='recovery'
The LiteSpeed xp_restore_database always requires the filename parameter.
