What are the challenges you face when working across database platforms? Take the survey
Options

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

etorresetorres Posts: 2
edited October 15, 2008 1:24PM in SQL Backup Previous Versions
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

Comments

  • Options
    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,
    Matthew Flatt
    Redgate Foundry
Sign In or Register to comment.