Setting the remote roots locations

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.

Remote root directories are set by the Administrator. Editing of remote root locations is restricted to database owners when user permissions are enabled and the Protect Global Settings option is on.

Remote root locations are set by the Administrator:

• When working with the supplied 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 database file.
• When working with a SQL Server database, the location of all remote roots must be set before the database can be used.
• When working with an Oracle database, the location of all remote roots must be set before the database can be used.

To set remote root locations:

1. Choose File | Master database settings | Set remote roots. This displays the Set Remote Roots dialog.
2. Set locations for each remote root by typing the pathname of the directory, or browse for a directory by 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.