Backing up MS SQL databases

1. Open the Enterprise Manager attachment:enterprise_manager.jpg

2. Select the database that needs to be backed up. Right-click on the database and then goto All Tasks and then Backup Database attachment:backup1.jpg

3. This should bring up the dialog shown below. Specify that you want a Complete backup. Click on Add to specify the location where you want the backup to be saved. Also ensure that the overwrite option is set to Overwrite existing media, otherwise you will end up with a file which has duplicate copies of the database. attachment:backup2.jpg

4. Click Ok on the dialog, and then it should proceed to backing up the database.

Restoring MS SQL databases

1. Open the Enterprise Manager as shown above.

2. Select the database that needs to be restored. Right-click on the database and then goto All Tasks and then Restore Database. attachment:restore.jpg

3. This should bring up the following dialog. Select the backup from which you want to restore. attachment:restore3.jpg

4. Click on Ok and the database will be restored.