sp_diskdefault lets you plan space usage carefully for performance and recovery, while allowing users to create or alter databases.
Make sure these devices are not default devices:
The master device (use sp_diskdefault to set defaultoff after adding user devices)
The device 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 with sp_diskdefault.
In most cases, devices that are to be mirrored or databases that
contain objects placed on segments should allocate devices specifically,
rather than being made part of default storage.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
