how to restore the database for localhost to server

Posted by Vanchi050585 under Sql Server on 3/29/2011 | Points: 10 | Views : 2089 | Status : [Member] | Replies : 1
hi all,

i am developing database in localhost, but i want to restore it into the server.

anybody please let me know about the procedure

thanks

Thanks
tvn



Responses

Posted by: Pavanandey on: 3/29/2011 [Member] Bronze | Points: 25

Up
0
Down
Hi ,

follow the below steps

on the localhost machine
1) right click on the database you created
2) go to tasks --->back up
3) give the back up location with file extension as .bak
4) set back up expires to some later dates

now move the .bak file to server

on server machine

1) create a database
2) right click on the database you created
2) go to tasks --->restore -->database
3) point to the back up you copied
4) click ok


Thanks
Pavan Kumar
Mark Answer if this fits the need

Vanchi050585, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response