Restore a Site Database from Backup Page - Intergraph Smart 3D - Administration

Intergraph Smart 3D Project Management

PPMProductFamily
3D Design and Visualization
PPMProduct
Intergraph Smart 3D
PPMCategory
Administration
Version_S3D
10.1(2014R1)

Database type

Specifies the type of database.

Destination database server

Specifies the server on which the restored site databases is to reside. Only those servers that are registered with Microsoft SQL Server display in the drop-down list. This option appears only if you select MSSQL as the database type.

Oracle service

Specifies the name of the Oracle net service for the site database connection. This option appears only if you select Oracle as the database type.

Local Net Services needs to be added with the Oracle Net Configuration Assistant. See your Oracle installation documentation for more information.

Backup configuration file to restore

Identifies or browses to the location of the backup configuration file to be used in restoring the site and site schema databases. The backup configuration file is the file that was created during the backup process and lists the paths and names of the backed up files. If you are running Oracle on Linux, the .bcf file must be on a Windows-based computer.

Database backup files are stored on the server in

Identifies or browses to the folder location where the site and site schema database backup files are stored. If you are running Oracle on Linux, the database backup location must be on the Linux computer where the Oracle service is running. The Oracle service account must have access to this folder. Remember that Linux is a case sensitive environment. You must type the folder path and file names in the correct case. The Browse feature is not available for navigating to Linux folder locations.

Site database name

Specifies a name for the restored site database. By default, the software populates this field with the original site database name as specified in the backup configuration file.

Site schema name

Specifies a name for the restored site schema database. By default, the software populates this field with the original site schema database name as specified in the backup configuration file.

Site database workshare location

Specifies a name for the workshare location for the site database. The workshare location is the location of the host site database and is required regardless of whether the host site database is going to be replicated.

Name generator server for site

Specifies a name for the server computer on which the Name Generator Service is configured. A name server must be a valid computer running on the Windows domain and one that has been properly configured to run as a name server.

Use new paths for physical database and log files

Specifies whether to use the default location or new locations for the Physical database and Log file (for SQL databases) or Data tablespace and Index tablespace (for Oracle database). If you do not select the checkbox, the software uses the default location.

Physical database

Identifies or browses to the location of the physical database. This field is only editable if you select the Use new paths for physical database and log files checkbox.

Log file

Identifies or browses to the location of the database log file. This field is only editable if you select the Use new paths for physical database and log files checkbox. This option appears only if you select SQL Server in the Database type list.

Data tablespace file name

Identifies or browses to location of the data tablespace for the site. This field is only editable if you select the Use new paths for physical database and log files checkbox. This option appears only if you select Oracle in the Database type list.

Index tablespace file name

Identifies or browses to location of the index tablespace for the site. This field is only editable if you select the Use new paths for physical database and log files checkbox. This option appears only if you select Oracle in the Database type list.

This page of the Database Wizard is only available as part of the Restore a site database from a backup set workflow.