Page 143 - DCAP508_DATABASE_ADMINISTRATION
P. 143

Unit 10: Database Backup and Restore




          3.   Select All Tasks, then select Backup Database... as shown in Figure 10.2. The dialog box  Notes
               shown in Figure 10.2 is displayed.

                                 Figure 10.2: Backup Database Dialog Box







































          4.   Provide a name for the backup in the Name text box. Leave the Database – complete radio
               button selected since we are performing a complete database backup.

          5.   Select the Overwrite existing media check box to initialize the destination file or device or
               select the Append to media check box to append the current backup to existing file or device.
          6.   To select a destination for the backup, click the Add button. The dialog box shown in
               Figure 10.3 is displayed.

                                 Figure 10.3: Select Backup Destination























                                           LOVELY PROFESSIONAL UNIVERSITY                                   137
   138   139   140   141   142   143   144   145   146   147   148