...
- Open Microsoft SQL Server Management Studio Express (Start > All Programs > Microsoft SQL Server 2008> SQL Server Management Studio).
- Login to Microsoft SQL Server.
- Right-click on Databases and click Restore Database.... The Restore Database dialog will be displayed.
- In the To Database field, enter the TFS Database Name.
Example: TFSMain
In the From Device field, click the Browse button. The Specify Backup dialog will be displayed.
- Click the Add button. The Locate Backup File dialog will be displayed.
- Select the folder and file location of the Microsoft SQL Server backup file.
- Typical Folder: \[tfs folder]\Service\01 - Default Data\
- Typical File: TFSSQL.bak
- Click the OK button. The Locate Backup File dialog will close.
- Click the OK button. The Specify Backup dialog will close.
- In the Restore column, tick the backup to be restored.
- Select the Options tab.
- In the Restore the database file as list, click the TFS Database Name (i.e., TFSMain) Browse button. The Locate Database Files dialog will be displayed.
OR
Use the default file location. - Select the folder location where the database will be restored to.
...
- Open The Finance Shop Administration (Start > All Programs > Insula Software > TFS Administration). TheSecurity Log On dialog will be displayed.
- Log on to the system using the Username and Password supplied on the Software Licence Certificate.
- From the Administration menu, select Sentinel Key. The Sentinel Hardware Security Key dialog will be displayed.
- Enter the following information:
- Key Code: Provided by Insula Software.
- Database Server Name: Server/workstation name that hosts the The Finance Shop database.
- Database DSN: The licence database name stored in the licence database. Typically TFSMain.
- SSPro Server Name: Server/workstation name that hosts the Sentinel Hardware Licence Key. Typically this is the same as the Database Server Name.
- Under the License System heading:
- Licence System DSN: TFSMain
- Click Refresh. The yellow coloured fields will populate.
- Click Save.
- Close the Sentinel Hardware Security Key window.
- Exit the The Finance Shop Administration Tool.
...