Create New Default Device Other Than Master

By default, the master device is the default device in a newly installed Adaptive Server. This means that, if you create any databases (including the proxy databases used by failover), they are automatically created on the master device. However, adding user databases to master 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, 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 failover.

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

disk init name=”money_default1”,
physname=”/home/moneyHA/money_default1.dat”,
size=40000, vdevno=2
go

At the next “>”, do:

sp_diskdefault money_default1, defaulton
go

Then turn off disk default on master:

sp_diskdefault master, defaultoff
go

See the Adaptive Server Reference Manual for more information about disk init and sp_diskdefault.