restoration failed during restore a backup file to ms-sql

I have my database backup file that i have downloaded from godaddy share hosting backup manager.After downloading the backup file i want to restore that backup file to vps server of godaddy so i create a database in vps account.Now i want to restore that database file to the newly create database .How can i do this.I am getting error.Any help will be greatly appreciated.Thank you..