Creating a new default device

master is the default device in a newly installed Adaptive Server. This means that any databases you create (including the proxy databases used by failover) are automatically created on the master device. Adding user databases to the master device makes it difficult to restore the master device from a system failure. To make sure that the master device contains as few extraneous user databases as possible, create a new device using disk init. Use sp_diskdefault to specify the new device as the default before you configure Adaptive Server as a companion for fail over.

For example, to add a new default device named money_default1 to the MONEY1 Adaptive Server, enter:

sp_diskdefault money1_default1, defaulton

The master device continues to also be a default device until you issue the following to suspend it as the default device:

sp_diskdefault master, defaultoff

See the Reference Manual: Commands for information about disk init. See the Reference Manual: Procedures for information about sp_diskdefault.