Page 146 - DCAP508_DATABASE_ADMINISTRATION
P. 146

Database Administration




                    Notes          10.3.1 Restoring a Complete Backup to the Same Database

                                   To restore a complete database backup to the same database follow the given below steps.
                                   1.  Open SQL Server Enterprise Manager and connect to the server where the backup is to be
                                       restored.

                                                  Figure 10.7: Restore Database Through Enterprise Manager

























                                   2.  Right-click the database and select All Tasks, then select Restore database (as shown in
                                       Figure 10.8). The Restore Database dialog box (Figure 10.8) is displayed.
                                                         Figure 10.8: Restore Database Dialog Box








































          140                               LOVELY PROFESSIONAL UNIVERSITY
   141   142   143   144   145   146   147   148   149   150   151