Remote Roots
Some master database data is not stored in the database file itself, but as separate files in remote root directories.
Remote root directories do not have to be on the same drive, or even the same machine, as the database.
Editing of remote root locations is restricted to database owners when user permissions are enabled and the Protect Global Settings options is on.
Everyone working with a particular master database should use the same remote root directories.
Setting remote root locations
Note:
- When working with a standalone database, the remote root directory is set to be below the master database by default. Data files are stored in a sub-directory of the directory containing the standalone database file.
- When working with a SQL Server or Oracle database, the location of all remote roots must be set before the database can be used.
To set remote root locations:
- Select the Master database settings | Set remote roots option from the File menu. This displays the Set Remote Roots dialog.
- Set locations for each remote root by typing the
pathname of the directory, or browse for a directory using the
button.
Files will be stored in a sub-directory of the specified Remote Root. The sub-directory name is the Unique Database Identifier for the master database.
For information about the files stored in the remote root directories, see File Locations.
