Size limit of DB

Business Central/NAV Technical Forum
1

Hi All,

Im not able to expand the DB after 4GB, if i try error is comin – there is no disk space but i have more than 13 GB in disk.

What is the maximum size limit of DB in navision and also max size of SQL DB.

Regards

Sam

2

Sam,

change the file system of the drive in which you are creating the database to NTFS. probably the current file system might be FAT32. To check, right click the drive letter in explorer and click properties and check the file system.

cheers

3

Another solution is to instead of expanding database file add another file to DB of 2G. Your DB will be 2G + 2G

4

Are you possibly running an “SQL Server 2005 Express Edition” ? This one only allowed databases up to 4GB - refert to http://www.microsoft.com/sql to learn more about Editions …

5

What version of SQL Server are you using? 2000 or 2005? Express or Enterprise?

If you are using SQL Server 2005 Express edition, then you have the answer here, as this version of SQL Server has a limit of 4 GB.

6

Some times I forgot that SQL Server Express has a limitation of 4G, I’m still thinking in old Native DB servers stored in FAT32. [:)]