Restore SQL Server 2008 database from SQlCmd

Open Command prompt and run following command.
  1. SqlCmd -E -S localhost -Q "RESTORE DATABASE <DATABASE NAME> FROM DISK='backup file path'"