What is the best proceedure to add a SharePoint 2010 content database to support users current structure?

I have a SharePoint 2010 application that is nearing the 200 GB limit.  I know that I can add another content database.  However, my understanding is that I would need to create a site collection in the new content database and have users add new content there.  However, there is an established structure in the original content database that users will continue add to (uploading files, creating sub sites, etc).  

What is the best procedure to support users adding content to the old stucture?
Michael CarrilloInformation Systems ManagerAsked:
Who is Participating?

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

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.

Jamie McAllister MVPSharePoint ConsultantCommented:
You have a few options, but several involve expenditure.

First off, look at the IOPS figures for your disk it may be fast enough to support a larger DB;


If not, consider tools such as Metalogix StoragePoint, which allow you to exceed the limit by offloading content to disk.

third; Consider duplicating the structure of your sites and libraries, perhaps by saving as templates and re-creating in the new site collection.

Fourth; You could migrate older content to the new site collection when it reaches a certain age, and free up space in your existing structure. Ideally this would need a migration tool to preserve metadata but could be done with Powershell too.

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
Michael CarrilloInformation Systems ManagerAuthor Commented:
All, very good suggestions.

So, If I understand correctly; the 200 GB limit, is not necessarly a hard limit, if you have a good hard drive system (IOPS)?
Jamie McAllister MVPSharePoint ConsultantCommented:
Correct. To be carefully assessed.
Michael CarrilloInformation Systems ManagerAuthor Commented:
Excellent help!
Thank You!

We actually have Metalogix here, but no one has training in it.
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 SharePoint

From novice to tech pro — start learning today.