The size and number of Adaptive Server devices depend on the following constraints:
The maximum device size is 4TB.
Each database can have up to 2G - 1devices.
The maximum database size is 4 – 32 TB (dependent upon page size.)
Although some operating systems can designate an entire hard disk to use as a database device, Windows 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.
