SQL Backup/LogShipping-Restore a DB that use multiple paths

etorres

Hi,
I have problems trying to restore a DB which use 4 different disks, to separate Data and Log files.
The restore option allows me to select just 1 disk(path) for Data and 1 Disk(path) for Log.

Does anyone know if it is possible to do it and how ???.

Thank you in advance for your help.

Cheers from Peru. Edgardo

Matthew Flatt

Hi Edgardo,

What version of the SQL Backup GUI/Server Components do you have installed?

You can check the GUI version by using Help>About.

You can check the Server Components version by right clicking it in the GUI and selecting Properties.

I can restore a database with multiple file groups to different locations using the SQL Backup 5.3 GUI.

You could also use the extended stored procedures to restore manually :

EXECUTE master..sqlbackup N'-SQL "RESTORE DATABASE [Filegroup]  FROM DISK = ''C:\Backup\FULL_SQL2005_Filegroup.sqb'' WITH RECOVERY, MOVE ''Test1dat1'' TO ''C:\Backups\Filegroup2Test1.ndf'', MOVE ''Test1dat2'' TO ''C:\Backup\Filegroup2Test2.ndf'', MOVE ''test1dat3'' TO ''D:\Data\Filegroup2Test3.ndf'', MOVE ''test1dat4'' TO ''D:\Data\Filegroup2Test4.ndf'', MOVE ''FileGroupTest_log'' TO ''D:\Log\Filegroup2Test_log.LDF''"'

I hope this helps,