How to run an Integrity Check on the IRIS database

You may be required to run a manual integrity check to make sure the data is all intact.

To do this:

1. Go to Start | All Programmes | SQL Server 2008R2 | SQL Server Management Studio

2. Connect into the SQL Server Instance.

3. Expand databases on the left-hand side and right-click on the IRIS database.

4. Select new query and type in DBCC CHECKDB with DATA_PURITY and click Execute.

5. Scroll down to the bottom few lines of the text box and check for any consistency or validation errors:
   

CHECKDB found 0 allocation errors and 0 consistency errors in database 'IRIS1'.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

The output indicates there are no errors with the database. Any errors need to be reported to the IRIS support team at; support@iris.co.uk