How to restore IRIS SQL when using SQL Server 2008 Management Studio

Introduction

This topic explains how to restore an IRIS SQL database using the tools provided with SQL Server 2008 Express (commonly referred to as SQL Express).

  1. Click Start, Programs and then click Microsoft SQL Server 2008 R2.

  2. Click SQL Server Management Studio.

  3. The connect box will be displayed. Under normal circumstances, the user will be able to click Connect without changing anything here:

 

  1. If the IRIS database has been created in an ‘instance’ other than machinename\IRISPRACTICE (the default), that instance will have to be selected at this point.

  2. If the instance name is not known, log into IRIS, click Help, select About and click the Details tab.

 

  1. The servername required is displayed along with the programs location and the IRIS data folder. In the example above, the programs are in c:\iris and the servername needed to connect to is displayed along with the database name.

  2. Once connected, the Microsoft SQL Server Management Studio screen displays;

 

  1. Click the + next to Databases to expand and show the databases available.

 

  1. Right-click on the appropriate database (normally IRIS) and click Tasks, Restore and then click Database.

 

  1. Click From Device and then click to display the Specify Backup window.

  2. Click Add.

 


The following window displays.

  1. Browse to the IRIS.bak file and click OK.

 

  1. Click OK again.

  1. Ensure the details are correct and select Restore.

 

  1. On the left-hand side of the screen, click Options.

  2. Select Overwrite the existing database and click OK.

 


Once the database has been restored, a message confirming the action will be displayed.

  1. Click OK and then close the SQL Server Management studio window.