How to back up IRIS using SQL Server Management Studio


This topic explains how to backup an IRIS SQL database using the tools provided with SQL Server Express (commonly referred to as SQL Express).  These steps are applicable for SQL 2008, SQL 2012, SQL 2014 & SQL 2016.


It covers making a manual backup to the \iris\data\sqlbak directory. This then allows the user to make a copy of the DATA folder ensuring all the user defined data in IRIS is backed up.

  1. Click Start | Programs | Microsoft SQL Server and then click Microsoft SQL Server Management Studio

  1. The connect box displays. 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.

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


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 | Backup


The Back Up Database – iris screen displays.

  1. Highlight the path listed in the Destination box and click Remove.

  1. Click Add.


  1. The Select Backup Destination screen displays.

  1. Click to the right of the File name field to display the Locate Database Files window.



The following screen displays.

  1. Select the folder where the backup will be saved. Enter a filename and click OK.

  1. Navigate to the IRIS programs folder, then into Data, then into the SQLBAK directory. In the file name: field, enter iris.bak.

  1. Click OK.

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

  2. Select Overwrite all existing backup sets and click OK.

  3. Click OK to instigate the backup.

A confirmation window will display once the backup has completed successfully: