September 2, 2014 at 8:10 am
Hi,
I have four databases one with 7 gbs and other 3 with 3 gbs each.
Can I use Express Edition ?
I read that the limit is about 10 GBs but I don't undestand if this limite is per database or the total of databases.
Another question is related with my jobs.
I have 4 maintenance plans. Dés the Express edition support maintnance plans?
Thank you
September 2, 2014 at 8:28 am
river1 (9/2/2014)
Can I use Express Edition ?
Yes. It's a per-database limit
I have 4 maintenance plans. Dés the Express edition support maintnance plans?
No. Express does not include SQLAgent.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2014 at 8:31 am
river1 (9/2/2014)
Hi,I have four databases one with 7 gbs and other 3 with 3 gbs each.
Can I use Express Edition ?
I read that the limit is about 10 GBs but I don't undestand if this limite is per database or the total of databases.
Another question is related with my jobs.
I have 4 maintenance plans. Dés the Express edition support maintnance plans?
Thank you
10GB per database on 2012 edition
No maintenance plans IIRC and no SQL Agent either. I use SCHTASKS to run batch files for maintenance on SQL Express instances. I have a client with many thousands of databases spread over hundreds of SQL Express instances. Also, NEVER user maintenance plans!! Go to Ola.Hallengren.com and learn to use the free AWESOMENESS Ola has there!
As for whether or not you can USE SQL Express is a COMPLETELY different question. The 1CPU/4core and 1GB memory limits can be SIGNIFICANTLY CONSTRAINING, especially if you are on one or a few rotating disks for IO. The version simply may not be able to process the information fast enough for you requirements.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply