Restoring the Optiva database schema

Optiva stores data in a Microsoft SQL Server database. The database structures and initial seed data supporting Optiva have been prepared in a database schema. This information is distributed in a SQL Server backup file.

To restore the Optiva database schema on an available Microsoft SQL Server instance, complete these steps.

Copy the backup file from the Optiva distribution CD to a folder on the selected SQL Server database server. The file name is of the format: Seed12xx WW.XX.YY.ZZ.bak.

File format	Description
`WW`	This is the major version number.
`XX`	This is the minor version number.
`YY`	This is the build number.
`ZZ`	This is the revision number.

Log into the SQL Server using SQL Server Management Studio and an account with System Administrator privileges.
Select Databases. Then, select Restore Database from the right-click menu. The Restore Database dialog is displayed.
Specify this information:

To database

Type any valid SQL Server database name. For the initial installation of an Optiva development database, use the name OptivaDev. For a production environment, OptivaProd can be used.

From Device

Select a backup file as the restore device. Click the ellipsis button to open the Specify Backup form.
Click Add to select the Optiva database backup file. Then, click OK.
Select the database.
Select the Options tab on the Restore Database form. Examine the file paths. These paths determine where the Master Data File (mdf) and Log Data Files (ldf) are placed.
Ensure that these file paths are appropriate for the server on which the database is being installed. Correct the file paths, as needed.
Click OK to restore the database. When the restoration of the database is complete, the Optiva database is installed on the SQL Server database server instance.