MSSQL database .bak file restore query

by rajesh 2012-05-02 23:57:07

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

916
like
0
dislike
0
mail
flag

You must LOGIN to add comments