|
Size: 1013
Comment:
|
Size: 1192
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 23: | Line 23: |
| attachment:restore.jpg | |
| Line 24: | Line 26: |
| 1. This should bring up a dialog | 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. |
Backing up MS SQL databases
- Open the Enterprise Manager attachment:enterprise_manager.jpg
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
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
Click Ok on the dialog, and then it should proceed to backing up the database.
Restoring MS SQL databases
- Open the Enterprise Manager as shown above.
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
- This should bring up the following dialog. Select the backup from which you want to restore. attachment:restore3.jpg
Click on Ok and the database will be restored.