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
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.
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
3. Click the + next to Databases to expand and show the databases available. Right-click on the appropriate database (normally IRIS) and click Tasks, Restore and then Database.
4. Click From Device and then click … to display the Specify Backup window.
5. Click Add
6. Browse to the IRIS backup file and click OK.
7. Click OK again.
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.
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.
10. Your IRIS database has been restored. Please click here to recreate your IRIS logins.
We are sorry you did not find this KB article helpful. Please use the box below to let us know how we can improve it.