I have read/heard that the maximum filesize of a table space file is 2
GB. We are normally operating on a Windows 2003 server computer using
NTFS as the type of file system.

Is 2 GB the maximum size in this situation?

Thanks

Nope, the 2GB limit was an old limit imposed by the FAT file system. The
file size limits are dependent on the file system used. The sizes for
various file systems and page sizes are summarized under:

ASA Database Administration Guide

Physical Limitations

Size and number limitations

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx...c?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

"Bill Williams" <billwilliams (AT) qcsoftware (DOT) com> wrote