The bakup's local name and physical database name must also be the same, This functionality is handeled by Sql Server Management Studio automatically when restoring manually, but this script allows it ...