what server to go to after sql express

HI I have a local sql express 2012 server that sends data to our webserver in a datacentre which also has sql express 2012 on it it. All has worked well but now have had to split the database into 2 as reached the 10 gb limit. What can I do next, it look like I have to go with the standard edition but we only have 5 users and seems big jump. And if I have to do it twice its a very big jump cost wise.
LVL 3
taz8020Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Aaron GoodwinSenior Applications AnalystCommented:
do you need to access all the data all the time?  Could you choose a date range of you earlier data, copy that to a new Archive database, then truncate the tables in your original database?  Run an index defrag on the original database then shrink it....follow this archiving process to keep your main database small and live, while the archived databases retain the old information?
Vikas GargAssociate Principal EngineerCommented:
Hello,

I think you should move your tables to other database which will give you more space per database.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott PletcherSenior DBACommented:
There's a technique that will make moving tables to other dbs much less painful.  The code doesn't have to change at all.

Simply move a large table(s) to other database(s), then create a synonym in the main db for that table that points to the other db.  Your code will still "see" all tables in the original db, no matter where they physically reside.  The code doesn't directly reference other dbs, so you can move data easily.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

udaya kumar laligondlaTechnical LeadCommented:
The zero cost solution is to use partitioning in SQL Server. You can read more about @ https://msdn.microsoft.com/en-us/library/ms190787.aspx .You may have to do some code corrections or the way synchronization happens.

You can try archiving some of the data manually, If you have data that is not accessed often, This also requires changes the way DB is accessed.

If you need only one DB and No issues with Internet connectivity You can try SQLAzure which is considerably less expensive than a standalone license, will not affect your existing code base.
Anthony PerkinsCommented:
>>The zero cost solution is to use partitioning in SQL Server<<
Pst,How on earth is that going to help the author?  You do realize that this is an Enterprise feature right?
taz8020Author Commented:
Thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.