I have a LocalDB database that is currently at 9GB, and the application will ultimately consume 20-30GB. Moving to Standard SQL is not an option.
My original plan was to move the largest table (5GB) into its own LocalDB database so that my Access 2010 front end talks to 2 LocalDB back ends. However, the 10GB limit is based on the size of the MDF file. Is it possible to move the big table into a secondary file group stored in an NDF file without having to split the database? If so, is there any limit to the total size of a LocalDB database with MDF file + NDF file(s), each <10GB?