Thank you for your feedback.

Was this useful?

How to restore IRIS using SQL Server Management Studio

Article ID

how-to-restore-iris-using-sql-server-management-studio

Article Name

How to restore IRIS using SQL Server Management Studio

Created Date

23rd April 2023

Product

Problem

I need to restore a backup of IRIS Accountancy Suite, how do i do this?

Resolution

screen

1. Click on the Windows icon and locate the application folder Microsoft SQL Server Tools. Once expanded select the program Microsoft SQL Server Management Studio.

screen

2. Click Connect to link to the IRIS SQL Instance.

  • If the IRIS database has been created in an ‘instance’ other than COMPUTERNAME\IRISPRACTICE (the default), that particular instance will have to be selected at this point.
  • If the instance name is not known, log into IRIS Accountancy Suite, click Help, select About and click the Details tab. This should display the instance you will need to connect to
screen

3. Click the + next to Databases to expand and show the databases available. Right-click on the appropriate database (normally IRIS) and click TasksRestore and then Database.

screen

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

screen

5. Click Add

screen

6. Browse to the IRIS backup file and click OK.

screen

 7. Click OK again.

screen

8. On the left-hand side of the restore database screen, select Options. Below Restore options, select Overwrite the existing database, then return to General.

screen

9. Check your destination is the IRIS database and the details of the backup is the date/time that you want to restore to. Once confirmed, click Ok to start the restore process.

screen

10. Your IRIS database has been restored. Please click here to recreate your IRIS logins.

Thank you for your feedback.

Was this useful?