How to restore PTP Accounts Production using SQL Server 2008 Management Studio

Introduction

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

• Please read all the information in this topic before starting the Restore.

1. Click Start | Programs and then click Microsoft SQL Server 2008 R2.

2. Click SQL Server Management Studio

3. The connect box will be displayed. Under normal circumstances, click Connect without changing anything here.

• If the PTPdatabase has been created in an ‘instance’ other than machinename\IRISPRACTICE (the default), that instance will have to be selected at this point.

If the instance name is not known, log into PTP Accounts Production, click Help | About and select the Details tab.

The Programs folder, SQL Server & Database name are displayed. In the example, the programs are in C:\IRIS, the server name is TCVMCAP\PTPACCOUNTS and the database name is PTPACCTS.

4. Click the + next to Databases on the left-hand side to expand and show the databases available.

5. Right-click on the appropriate database (normally PTPACCTS) and click Tasks, Restore and then click Database.

6. Click From Device and then click  to display the Specify Backup screen.

7. Click Add.

The following screen displays.

8. Browse to the backup file, for example, PTPACCTS.bak and click OK.

9. Assuming the default location has been used; navigate to the IRIS programs folder, then Data, then to the SQLBAK directory. In the ‘File name:’ field, enter PTPACCTS.bak.

10. Click OK.

11. Click OK again.

12. Ensure the details on the Restore Database screen are correct and select Restore.

13. On the left-hand side of the screen, select Options.

14. Select the Overwrite the existing database option and click OK.

Once the database has been restored, a message confirming the action displays.

15. Click OK and then close the SQL Server Management studio window.

• Once the database has been restored please follow the steps below to recreating the PTP login.

For Windows XP or Server 2003 computers

1. Click Start | Run

2. Type in cmd and click OK.

For Windows Vista, Windows 7 or Server 2008 computers

You will need to locate the Command Prompt

1. Click Start | Programs | Accessories –

2. Right-click on Command Prompt and select Run as administrator.

A command prompt window displays.

3. Change directory to the PTP folder (see the path in the Help | About screen at the beginning of this topic).

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

5. Type createpracticelogin computername\instancename databasename

• Computer is the name of the PC (to find this out, at the command prompt type in hostname and press Enter).
  
  Instancename is the SQL instance name that holds the PTPdatabase (if you installed SQL from the PTP CD this is PTPACCOUNTS).
  
  Database is the name of the PTP database (by default this is PTPACCTS).

It should now be possible to load PTP Accounts Production.