Restoring backups from an alternate location
You can restore from an alternate location to restore the data files from an intermediate file system to an active file system.
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