SQL Server Express Size Limit

SQL Server Express Size Limit

Common scenario:

A company is using SQL Server Express edition to save on licensing costs for a small database. Over time this database grows and is getting close to the hard 10GB limit.

I just got off the phone with a client and their client is in this situation. During the conversation, she mentioned that the DB has information for four "regions."

They already have a purge process in place, and data compression is not an Express Edition feature.

Options I gave:

  • Decrease the retention (her client already said no to this)
  • Split the data into 4 databases - 1 for each region (Might require some re-work of applications and connection strings)
  • Install a second Express instance and split the data between them (Easier on their app)
  • Convince the end customer to buy SQL Standard (1% chance this is going to happen)
  • Buy Standard Edition for them and eat/split the cost to keep a huge customer happy
  • Move to a different platform (nope...all SQL Server shop)
  • I saw a blog post that you can bypass 10GB by using the Master database instead (That's the worst idea I've ever read. )

If you have other legitimate things I should add to this list that Microsoft will support, please share in the comments.

Conclusion:

If your data is important, buy the proper version for your needs. Maybe that's Standard, maybe an Azure VM and spread out the SQL licensing over many months. But don't do crazy things to try to get around the limits.

Victor Escott

Vice President of Engineering | SQL Nerd | Azure & Power BI | System Engineer | Leadership Advocate

4 年

If it's a web a application and serving as such , I would say the cheapest way would be SQL Web edition with Azure or AWS. I do have some small ones (GP_S_Gen5_1) with Azure and it's around $300 per month. Way better than express edition :)

回复
Alan Sproat

Native App Developer on Android and iOS platforms including back end AWS/Python and .Net Web APIs

4 年

Worst idea *I* have ever read is using SQL Express for a production database. Isn't Standard like just under a grand? A place with 4 regions, it would seem, wouldn't even blink at that given the support and increased capabilities.

回复

要查看或添加评论,请登录

Kevin Hill的更多文章

  • SQL Server Source Control on a $0 Budget

    SQL Server Source Control on a $0 Budget

    The Source Control Dilemma Every DBA has been there. Trying to keep track of database schema changes while developers…

    3 条评论
  • My SQL Server is Slow! What Do I Do First?

    My SQL Server is Slow! What Do I Do First?

    It’s a vague but common complaint, frequently with no additional details Before blindly restarting SQL Server, let's…

    16 条评论
  • What IT Leaders Need to Know About SQL Server Performance

    What IT Leaders Need to Know About SQL Server Performance

    IT leaders have a lot on their plates! Budgets, staffing, security, uptime, and keeping everything running smoothly…

    4 条评论
  • Mistakes IT Shops Without a DBA Make

    Mistakes IT Shops Without a DBA Make

    We get it. There’s no budget for a DBA on staff, or even a contract support firm like Dallas DBAs.

    10 条评论
  • SQL Server Time Bombs!

    SQL Server Time Bombs!

    Common Reasons for Emergency SQL calls If you are a production DBA (or Accidental prod DBA) you’ve gotten that frantic…

    10 条评论
  • Careers in Data

    Careers in Data

    Some of the highest paying careers in the field of "data". These are not necessarily specific to SQL Server, or even…

    1 条评论
  • High Availability for Databases: Pros, Cons, and Hidden Costs

    High Availability for Databases: Pros, Cons, and Hidden Costs

    High Availability is a must for critical databases, but is it right for your business? Every company says they want…

    10 条评论
  • Managing Stress for IT Workers

    Managing Stress for IT Workers

    IT professionals often face demanding schedules, tight deadlines, and the pressure of maintaining critical systems…

    3 条评论
  • Critical Thinking is Not Going Away

    Critical Thinking is Not Going Away

    In the ever-changing world of IT, tools and technologies evolve at a breakneck pace. New solutions are introduced…

    5 条评论
  • Staying Focused in 2025

    Staying Focused in 2025

    Top 3 Ways to Stay Focused and Make Progress as an IT Professional System administrators, developers and DBAs are no…

社区洞察

其他会员也浏览了