How to backup and restore into MSSql server 2000, 2005, 2008

Posted by Olumeyan under C# on 5/28/2013 | Points: 10 | Views : 1142 | Status : [Member] | Replies : 2
How to backup and restore into MSSql server 2000, 2005, 2008
using Visual C# 2008 as a desktop application.Please help am novices




Responses

Posted by: Ankitsrist on: 5/29/2013 [Member] Starter | Points: 25

Up
0
Down
when you open sqlserver studio you will get the Database folder in your object explorer, right click on it there is restore database option just click it and configure according to your need

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

Posted by: Raja_89 on: 6/7/2013 [Member] Starter | Points: 25

Up
0
Down
Hai
Start the Sql Server Management Studio.
In Summary[After opening Sql Server Mgmt studio a window came which lists are there]

1.Right click Database

To create a backup choose Attach

To create a Restore from external source [.bak] click Restore Database


Regards

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

Login to post response