MSSQL database .bak file restore query

create .bak file of the local database in a plesk server

a) create a database account and a user account using plesk or Sql Server Management Studio as same as that in .bak file

b) Login to RDP

c) Open "Sql Server Management Studio" and Select Database

d) Click "New Query"

e) enter the query

RESTORE DATABASE AccountName
FROM DISK = 'C:\databasename.bak'
WITH REPLACE

give proper path instead of C:\databasename.bak