Wednesday, July 7, 2010

Native FDB database limit

ever wonder about that? here's the explanation that i've got from partnersource

The maximum database size for a Microsoft Dynamics NAV native database is summarized in the following table:

Microsoft Dynamics NAV Version Maximum Database Size in GB
2.50 - 2009 256 GB
2.00 - 2.01 32 GB

By default, customer licenses have a maximum database size of 64 GB. However, the maximum database size can be increased to 256 GB for versions 2.50 to 2009 by adding granule 1370 - Database Expansions per 1 GB to the license (a maximum of 192 of granule 1370 can be added to a license).

Notes:
• The version of the Microsoft Dynamics NAV executables determines the maximum database size.
• The maximum size of an individual database file is 130,922,000 bytes. If you try to expand a database file beyond this size, you receive the following error message:

The maximum permitted value is 130922000

Therefore, any database larger than this must be expanded by using multiple database files.
To see the licensed size of a database in Microsoft Dynamics NAV, click File, click Database, click Information, and then click the Database tab.

Important:
Large databases should not be used on systems that do not support HotCopy. HotCopy is available in Microsoft Dynamics NAV 3.01 and later versions of Microsoft Dynamics NAV

No comments: