Differences between revisions 1 and 3 (spanning 2 versions)

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.
This should bring up a dialog

-  ⇤ ← Revision 1 as of 2006-07-07 00:38:13 → 
  Size: 107
  Editor: FayezMoussa
  Comment:
+   ← Revision 3 as of 2006-07-07 00:49:43 → ⇥
  Size: 1013
  Editor: FayezMoussa
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 3:
-attachment:aegis/enterprise_manager.jpg
+ 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'''.

 1. This should bring up a dialog