Its because the .mdf
and .ldf
Files from the original Db
were locate at maybe c:\programFile\....
and this info is saved in the Backup!
If you create the same DB on a different SQL Server where the installation is on c:\program Files (x86)\ ....
you can not restore as usually. You need to relocate the path for .mdf
and .ldf
Files.
Therefore:
Create a empty DB on the new Server
Right click on the empty Db > Tasks > Restore > Database > click Device select your .bak
Files > Select Db to restore into
Done!
Hope it helps!