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.
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.
