= Backing up MS SQL databases =
 1. Open the Enterprise Manager

 {{attachment:enterprise_manager.jpg}}

 1. 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}} 

 1. 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}}

 1. 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.

 1. 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}}

 1. This should bring up the following dialog. Select the backup from which you want to restore.

 {{attachment:restore3.jpg}}

 1. Click on '''Ok''' and the database will be restored.
----
CategorySql