-sbx database server option

Off

All operating systems.

This option specifies the default disk sandbox settings for all databases started on the database server that do not have explicit disk sandbox settings. The -sbx database option, which explicitly specifies disk sandbox settings for a database, overrides the -sbx database server option.

Enabling this option restricts the read-write file operations for all databases running on the database server to the directory where the main database file is located and any subdirectories of this directory.

Change the default disk sandbox settings for the database server while the database server is running by using the DiskSandbox option in the sa_server_option system procedure. The sa_server_option system procedure does not affect databases that have already been started on the database server or databases that have explicit disk sandbox settings.