-
Open the Database Wizard.
-
On the Introduction to Database Wizard page, select Restore a site from a backup set, and click Next.
-
On the Restore a Site Database from Backup page, select the type of database from the Database type list.
-
For SQL Server databases, use the Destination database server list to select the server on which you want the restored site database to reside. Only those servers that are registered with Microsoft SQL Server display in the drop-down list.
For Oracle databases, select the name of the Oracle net service in the Oracle service list for the site database. Only those Oracle local net services that are added with the Oracle Net Configuration Assistant display in the drop-down list.
-
In the Backup configuration file to restore box, type the location of the configuration file to be used to restore the site and site schema databases. Click the Browse button to navigate to the folder. If you are running Oracle on Linux, the .bcf file must be on a Windows-based computer.
-
In the Database backup files are stored on the server in box, type the location of site and site schema database backup file. Click Browse to navigate to the folder. If you are running Oracle on Linux, the database backup files must be on the Linux computer where the Oracle service is running. The Linux account used for the Oracle service must have access to the folder. Remember that Linux is a case sensitive environment. Folder paths and file names must have the correct case when typed. The Browse feature is not available for navigating to Linux folder locations.
-
In the Site database name and Site schema name boxes, type a name for the restored site and site schema databases. By default, the software populates these fields with the original site and site schema database names as specified in the backup configuration file. If you are restoring the site database at a satellite location participating in a Workshare, the site and site schema databases must be named identically to those that reside at the host location.
-
In the Site database workshare location box, type the name of the workshare location for the site database. The workshare location is the location of the host site database and is required even if the host is not going to be replicated.
-
In the Name generator server for site box, type the name of 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.
-
In the Paths for site database and schema files section, check the Use new paths for physical databases and log files box. If you are not restoring the site and site schema databases on the same computer that created the backup file, you must type the path information for that computer.
-
Click Next.
-
On the Ready to Restore Database page, click Next.
-
Click Finish.
-
After you have restored the site and site schema databases, you can then restore the catalog, catalog schema, and model databases using the Restore Command.
-
To be restored, the model must exist in the site. If the model was deleted, it cannot be restored unless the whole site is restored.
-
If the backup set you used to restore site and site schema databases was created with a previous version of the software, you can use the Database Wizard to upgrade the site and site schema databases to the current software version.