The master device is the default device in a newly installed Adaptive Server. This means that, if you create any databases (including proxy databases used by failover), they are automatically created on the master device. However, adding user databases to the master device makes it more 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, use disk_init to create a new device. Use sp_diskdefault to specify the new device as the default.
For example, to add a new default device named money1_default1 to the MONEY1 Adaptive Server, enter:
sp_diskdefault money1_default1, defaulton
The master device continues to be a default device until you specifically issue this command to suspend it as the default device:
sp_diskdefault master, defaultoff
See theReference Manual: Procedures for more information about disk init and sp_diskdefault.
