It’s not supported to run full SQL (standard or enterprise) on a DC. I don’t know if it’s a hard block or not.
From: [email protected] [mailto:[email protected]] On Behalf Of Bill Humphries Sent: Monday, November 14, 2016 4:16 PM To: [email protected] Subject: RE: [NTSysADM] sql express database limit They are running sql express 2012. I am using a utility to backup and zip the backups nightly. This zip has been about 6 gigs. I just did a backup of the database using the LOB backup utility to see size there and the bak file was 20 gigs. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Eric Wittenberg Sent: Monday, November 14, 2016 4:00 PM To: [email protected]<mailto:[email protected]> Subject: Re: [NTSysADM] sql express database limit 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]<mailto:[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<http://www.red5support.com> o:404-919-8002<tel:404-919-8002> c:770-548-1781<tel:770-548-1781> Like us: [facebook] <https://www.facebook.com/pages/Red-Five-LLC/349345845176301> [linkedin] <http://www.linkedin.com/company/red-five-llc?trk=company_logo>
