Restoring backups from an alternate location
You can restore backups from an alternate location to restore the data files from an intermediate file system to an active file system, or to restore the blocks of data from an intermediate raw device into an active raw device.
Create a restore specification XML file and specify the type of restore method you want to use.
You can use the smo backup restore command and specify the restore specification XML file you created to restore the backup from an alternate location.
Enter the following command: smo backup restore -profileprofile-labellabel-complete-alllogs-restorespecrestorespec