Unable to restore using the same name and filegroups.
For example, the files on the primary FG named:
DBName.mdf
DBName_Data1.ndf
DBName_Data2.ndf.
There's an Index FileGroup with files named:
DBName_Index1.ndf
DBName_Index2.ndf
and another FileGroup with specific tables named Tables FileGroup.
The following files are in this FG:
DBName_Tables1.ndf
DBName_Tables2.ndf.
When restoring with Litespeed, the Restore Database Wizard only displays the option of DBName.mdf
DBName_Data1.mdf......DBName_Data6.mdf, etc.
The original filename is not displayed nor is there an option to restore files to individual filegroups.
The path of an existing database is displayed.
In the Restore Database Wizard, on the Restore Destination screen, select restore to a NEW database option. The format will be carried over to the NEW database.
Complete example, using LiteSpeed parameters:
EXEC master.dbo.xp_backup_database @database='FILEGROUPTEST' ,
@filename= 'C:\Backups\FileGroupTest_Primary.sls' , @filegroup = 'PRIMARY' , @init= 1
EXEC master.dbo.xp_backup_database @database='FILEGROUPTEST' ,
@filename= 'C:\Backups\FileGroupTest_FG1.sls' , @filegroup = 'FG1' , @init= 1
EXEC master.dbo.xp_backup_log @database='FILEGROUPTEST' ,
@filename= 'C:\Backups\FileGroupTest_log.sls' , @init= 1
execmaster xp_restore_database
@database = N'FileGroupNew',
@filename = N'C:\Backups\FileGroupTest.sls',
@filenumber = 1,
@with = N'STANDBY = N''D:\Backup\undo''',
@with = N'NOUNLOAD',
@with = N'STATS = 10',
@with = N'REPLACE',
@with = N'MOVE N''FG1'' TO N''c:\Program Files\Microsoft SQL Server\MSSQL\Data\FileGroupNew_Data.mdf''',
@with = N'MOVE N''FG2'' TO N''c:\Program Files\Microsoft SQL Server\MSSQL\Data\FileGroupNew_Data1.ndf''',
@with = N'MOVE N''LogFile'' TO N''c:\Program Files\Microsoft SQL Server\MSSQL\Data\FileGroupNew_Log.ldf''',
@with = N'MOVE N''PrimaryFile'' TO N''c:\Program Files\Microsoft SQL Server\MSSQL\Data\FileGroupNew_Data2.ndf'''
Each Native parameter has an equivalent value in LiteSpeed script.
(Native) Filegroup =
(LiteSpeed) @Filegroup =
(Native) To Disk =
(LiteSpeed) @Filename =
(Native) Read_Write_Filegroups =
(LiteSpeed) @Read_Write_Filegroups = 1
For additional information, see the following articles: https://support.microsoft.com/en-us/kb/281122 https://technet.microsoft.com/library/Cc966495#E3KAG https://technet.microsoft.com/en-us/library/ms179401.aspx
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center