Restoring the database

  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.
  3. Select the database to be restored.
  4. Select the option From Device and click Browse.
  5. Click Add to browse for your back up location.
  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.