Restoring the Database

Restore the database as follows:

  1. On the Start menu, point to Programs Microsoft SQL Server and click SQL Server Management Studio.
  2. Right-click IRC Database Tasks->Restore. The Restore database screen is displayed, as shown below.
    General section of Restore database screen

    In the General section,

  3. From the drop-down list select the database to be restored.
  4. Select the option From Device and clickbrowse icon.
    Specify Backup destination
  5. Click Add to browse for your back up location.
    Selecting folder for backed up database
  6. Select the folder where you backed up the database.
  7. Click OK.
    Note: Restoring overwrites the existing database or creates a new database if one has not been created earlier.