How to Restore a SQL Database for PTP Accounts Production

This topic explains how to restore a PTP Accounts Production SQL database using the tools provided with SQL Server 2008 Express.

1. Click Start | Programs | Microsoft SQL Server 2008 R2 – SQL Server Management Studio

• For Windows 7 or Server 2008, you may need to right click on SQL Server Management Studio and choose Run As Administrator.

2. In the Server name field, select the PTPACCOUNTS instance.

• PTPACCOUNTS is the default SQL instance name for PTP Accounts Production. If you have installed PTP Accounts Production to a different SQL instance, then select that at this stage.

• If the instance name is not known, open PTP Accounts Production, click Help – About and go to the Details tab.

The programs folder, server name and database name are displayed on this screen. In the example above, the programs are in C:\IRIS, the server name is TCVMCAP\PTPACCOUNTS and the database name is PTPACCTS.

3. Click the + next to Databases on the left-hand side:

4. Right-click on the appropriate database (normally PTPACCTS) and choose Tasks – Restore – Database…

5. Select the From device: option:

6. Click the …  (to the right of the From device option).

7. On the Specify Backup screen, click Add:

8. In the Locate Backup window, browse to the location of your backup file.

9. Highlight the backup file.

10. Click OK.

11. On the Specify Backup screen, click OK.

12. On the Restore Database screen, select the option next to the database you want to restore.

13. Click the Options link.

14. Select Overwrite the existing database (WITH REPLACE).

15. Click OK.

16. Once the restore is complete you will get the confirmation message. Click OK.

• Once the database has been restored, you will need to recreate the PTP login scripts. See below for details.

Recreating the PTP login scripts

For Windows XP or Server 2003 machines:

1. Click Start – Run.

2. Type in cmd and click OK.

For Windows Vista, Windows 7 or Server 2008 machines:

1. Click Start.

2. Type cmd into the Search box and press Enter.

3. This will open a command prompt. You now need to change to the PTP folder (see the path in the Help – About screen from the start of this guide).

4. Type cd\ and press Enter.

5. Type cd IRIS and press Enter (this assumes that C:\IRIS is the folder the program is installed to). If the programs folder is C:\apps\IRIS, then you need to type cd apps\IRIS

6. Type hostname and press Enter.

7. Type createpracticelogin hostname\PTPACCOUNTS PTPACCTS and press Enter (where hostname is the result from the previous step and PTPACCOUNTS is the SQL instance name used for PTP).