The database size limit for SQL Express has been 10GB since 2008r2, 2016 is no different.
Note that that's per database, it's entirely possible to make another database and work through them based on month/quarter and work around the limit in that fashion. https://www.microsoft.com/en-us/sql-server/sql-server-editions-express https://msdn.microsoft.com/en-us/library/cc645993.aspx Nathan Shelby [email protected] 425-205-9047 On 14 November 2016 at 12:59, Eric Wittenberg <[email protected]> wrote: > I've had dozens of very small clients who ran SQLExpress for Pos software. > Does your client have a more current version of SQL as the DB size is > different for older versions of SQL Express? > > Eric Wittenberg > > On Nov 14, 2016 1:41 PM, "Bill Humphries" <[email protected]> wrote: > >> Hi all, >> >> >> >> I have a small client that runs a single physical server that has >> essentials role installed on it, as well as running their LOB application >> on sql express. It seems they have been uploading photos at a rapid pace >> from smartphones into this app which has blown up the database to the limit >> of express. I know it isn’t best practice, but sometimes used in small >> businesses to install sql on a domain controller. Are any of you doing >> this with success or have horror stories about why not to do this? This is >> a small business with about 10 users connecting to the server. The LOB is >> a crm and dispatch system. >> >> >> >> Bill >> >> >> >> Bill Humphries >> >> Red5 >> >> Superior IT >> >> www.red5support.com >> >> o:404-919-8002 >> >> c:770-548-1781 >> >> Like us: [image: facebook] >> <https://www.facebook.com/pages/Red-Five-LLC/349345845176301> [image: >> linkedin] <http://www.linkedin.com/company/red-five-llc?trk=company_logo> >> >> >> >
