The size and number of Adaptive Server devices depend on the following constraints:
The maximum device size is 32GB.
Each database can have up to 128 devices.
The maximum database size is 4TB.
Although some operating systems can designate an entire hard disk to use as a database device, Windows NT accepts only an operating system file (.dat file) as a database device.
When you install Adaptive Server, the program creates a .dat file in the \data directory of the Sybase installation directory. To use a .dat file as a database device, you can either use the default d:\sybase\data directory or create a device and a directory in which to store it.