Chris Chilvers (4/26/2007)
The backups store the path of each file that was backed up, by default a restore will restore these files to the same path.
The trouble comes when restoring on a different machine where this path does not exist. If you're doing the restore through Sql Managment Studio then you can change the path each file will be restored to by going to the "Options" page and changing the "Restore As" value.
Thank you SO MUCH for posting this. I was stuck with the same issue and was pulling my hair out because nothing I tried worked.