sp_diskdefault lets you plan space usage for performance and
recovery, while allowing users to create or alter databases.
Do not use these devices as default devices:
-
The master device
-
The device used for sybsecurity
-
Any device intended solely for logs
-
Devices where high-performance databases reside
You can use the device that holds sybsystemprocs for other user
databases.
Note:
If you are using disk mirroring or segments, exercise caution in deciding which devices
you add to the default list. In most cases, devices that are to be mirrored, or databases
that contain objects placed on segments should specifically allocate devices, rather than
being made part of default storage.