By default, master is the default device in a newly installed Adaptive Server. This means that any databases (including proxy databases used by fail over) are automatically created on the master device. However, having user databases on the master device makes it more difficult to restore from a system failure.
To make sure that the master device contains as few 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 money_default_1 to the MONEY1 Adaptive Server, enter:
sp_diskdefault money1_default1, defaulton
The master device continues to be a default device until you specifically make it a non default device:
sp_diskdefault master, defaultoff
See the Reference Manual: Commands for information about disk init and see the Reference Manual: Procedures for information about sp_diskdefault.
