Device Requirements

Device requirement constraints on the size and number of Adaptive Server devices.

For Adaptive Server devices:

  • The maximum device size is 4TB.

  • Each database can have up to 2G - 1devices.

  • The maximum database size is 8 – 64 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.

Parent topic: Manage Database Devices